>>>Thank you. I will try the same code. I tracked my problem to the fact that the command specified in the BeforeInsert never fires (I put some bogus field name but no error occurred). I even "bypassed" creating a SP and assigned value but still no luck. Puzzling ..
>>
>>
>>Maybe you didn't insert records? :-)
>>Maybe you just update the fields of the existing ones? :-)
>>(sorry, but today I speak with such person that I should ask these questions :-))
>
>I did insert a record since I see it in the cursor after TableUpdate(). And the values in the fields are what I enter them. But the problem is that no matter what I do in the BeforeInsert(), the action is not reflected on the cursor. And since BeforeInsert() fires (I have a messagebox there) it means that the Insert action is fired by CA.. Right?
As Naomi said, you should call TABLEUPDATE(). That way you send the updates/inserts/deletes back to SQL Server.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.