Hi Fabio

thanks for the reply. I am only interested in the multiple record update situation on large files.

I'm not quite sure what you mean by "because you can use a variable" for ODBC. Could you elaborate?

Thanks in advance
Geoff

>>Hi
>>
>>If I have two fields being changed in an update or replace statement is it valid to rely on a the changed value of the first field in the statement when setting the second or should I always do two passes?
>>
>>eg.

UPDATE mytable SET ;
>>	field1 = CalcForwardTime(), ;
>>	field2 = OtherCalc(field1)

>>
>>Regards
>>Geoff Scott
>
>In VFP yes ( field1 get the new value ), in MSSQL no ( because you can use a variable )
>
>The VFP choice is not good.