Modify field value

[shamad]

Hi All,

I would like to change the value of a field.

Example
I have a table with tree filds Cod_customer f, Type, Name
10, AA, Bart
20, BB, Tony
30, CC, Alain

If cod_cutomer = 30 Then
Type = 'AA'
end if

The new value ist available at all my document.

[martin59]

Hi,

In your QV load script, you have to do this :

MyTable:
LOAD Cod_customer,
if(Cod_customer=30,'AA',Type) as Type,
Name
FROM MyFic;