>>Hello,
>>I working with a Local View for the first time and I'm running into a problem with the update. After I issue my TableUpdate() the new record seem to be there. I can recall it and edit it. When I exit the application, then go back in, it's gone! I'm using VFP 6.0 SP3. I have both the table and the view set-up ad 3-Optimistic Row Buffering. I've tried it with 5-Optimistic Table Buffering also. It seems that the View creates a temporary file, but it is never written back to the table. I have a primary key and all of the fields are marked for update in the View designer.
>>
>>What am I doing wrong?
>>TIA
>
>On theat same tab where you marked all fields as updatable, did you check the box to Send SQL Updates?
That did the trick. Thanks
Alan Trosky
MIS Director
Pennsylvania Bar Association
Harrisburg PA 17108