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.
>
If it's not broken, fix it until it is.
My Blog