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.
May all your weeds be wildflowers