Just let me know what the problem was.
>Agnes,
>
>Thanks for your help. I hope my colleague will now be able to figure this out.
>
>>Naomi,
>>
>>to me this looks like the ID field is not written from CA to the database, and the database uses a default value.
>>
>>Check values of
>>UpdatableFieldList and UpdateNameList
>>
>>for the ID field. Check that UpdateNameList holds the right DBC!Table.Field expression for the target.
>>
>>I do not understand if you create the record with the CA or just update an existing one.
>>
>>But this is not a big problem
>>
>>Use the Method BeforeUpdate (add some code like)
>>LPARAMETERS tcFldState, tlForce, tnUpdateType, tcUpdateInsertCmd, tcDeleteCmd
>>?tcUpdateInsertCmd
>>debug
>>suspend
>>
>>
>>Check the output, this should be the command that is used for UPDATE or INSERT for the field you are missing.
>>
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]