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?
>I want to have a CA class check to make sure a field is filled in before sending an insert to a database.
>
>I added the code to make sure the field is populated in the Before Insert but the CA class has already built the Insert Command by the time the BeforeInsert event fires.
>
>I know I could rebuild the cInsertCmd parm to include this new value but I was wondering if there is a easier way. Maybe another event that fires before the cmd is built or a way to force the CA class to rebuilt the statement from within the BeforeInsert Event.
>
>Thanks,
>
>Patrick
Mark McCasland
Midlothian, TX USA