>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)