>>Hi, Thank you. I am doing that. But I am looking for the good old approach of doing things in memory variables
>>and keeping the control myself rather than believing in the buffers and updates and reverts.
>>
>>By the way do you have any book covering VFP 5.0 or can you recommend one for intermediate to
>>advanced level
>>
>>thanks for the help
>>
>>alex
>Alex,
>
>When you use buffering you are taking control. Just be sure to use Table buffering and nothing wqill ever happen automatically, you will need to TableUpdate() or TbaleRevert() as needed. Think of TableUpdate() as GATHER MEMVAR, if you don't do it then the table is not updated. The only real difference is that you must do a TableRevert() to discard the changes or else VFP will give an error when you try to close the table.
>
>As for VFP 5 books there are a couple of them out there but I haven't read any of them. The VFP 3 books are fine for VFP 5. There really wasn't that much added to VFP 5 to warrant a new book.


Hi,

Thank you very much for such a fabulous reply. It is a pleasure to have the help of an expert to a novice. I
am always using Optimistic Table buffering. But the problem is I want to check the user entered primary key
to be validated before the user leaves the field and before updation to the table. If I include the validation
routine with the table buffering I get some violation errors which I dont know how to control. That is why I am
forced to stick to the updation of the records from the memory variables.

thanks very much

alex