Eyvind,
if you change a field that was not previously changed, then you might need to alter the cUpdateInsertCMD parameter.
This is the command that is used to alter the "base" table. Have a look into it and you will see.
I'm not sure on the next so have a try.
There is also the BeforeCursorUpdate event involved in the update. Try if it fires before BeforeUpdate. If it does, then you might enter your code there.
Agnes
>I am using CursorAdapters to access both native fox tables and tables on a SQL server through ADO. This works great, most of the time, but today I came accross a little "quirk":
>
>If the value of a field in the cursor is changed in the BeforeUpdate event of the CursorAdapter, the table in the database is updated with the new value as expected if the datasource is ADO. However, if the datasource is Native, the change that was done in BeforeUpdate is not respected.
>
>This seems like a bug to me, any ideas?
>
>Thanks,
>
>Eyvind.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]