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?
>>
Mark McCasland
Midlothian, TX USA