>>>>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?
>
>Did you set AutoUpdate property of the CA as in Boris sample? E.g. compare all properties of CA with the sample.
I just asked him a minute ago this question about AutoUpdate property. I don't see it in the VFP help on CA. It is possible that this is what I am missing.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham