thanks Fabio

If the Visual Foxpro choice works why is it not a good choice (perhaps cos is hidden)?

Regards
Geoff


>>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?
>>
>ODBC it is out of the matter
>
>On MSSQL you can get the field new value with:
>

>DECLARE @field1 ...
>UPDATE myTable SET @field1=field1=CalcForwardTime()
>                ,  field2 = OtherCalc(@field1)
>