The value of the I am storing is the Parent Tables ID#. I am moving to a DB2 backend from VFP. In VFP this field had a default of ParentTable.ID and that worked well but DB2 will not know what the current record of the Parent Table is.
>Also, you could just use a default value in the table and not deal with this in the CA. This is a much better approach unless you have to go through some business logic to determine what that value should be.
>
>>It does look like that. But if crsMyCursor.crsField1 did not have a its value changed prior to the BeforeInsert event it will not be included in the InsertCmd.
>>
>>
>>
>>>Yes, but the InsertCmd should look like
>>>
>>>...VALUES (?crsMyCursor.crsField1, ?crsMyCursor.crsField2, ...)
>>>
>>>and not have the actual field values in the SQL command. If this is not true, can you post what the actual Insert command looks like?
>>>
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement