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?
>>>
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only