Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;