by the way, thanks again.
JD

>>no, no other code.
>Ok did you change 'MyTableName' in the tableupdate to the name of your table (and what is your table name). Did you set the BufferModeOveride on the table in the forms DE?
>
>>I'm looking at DESI, and there are no databases, free tables, or queries in the project manager. I have databases and tables in mine, and I put them in the DE. Does that hold any clues?
>
>That's fine. If you look at the frmClients form's DE in DESI you will see a table (it's buffermode override is set to 3). Look at the MainTableForm under the Classes tab. All the code is in that class. Look at the OkButton and CancelButton methods (not the buttons themselves - the buttons call those 2 methods). That is the code the buttons call to save and cancel changes.
>
>>
>>BTW, I keep hearing about SQL being used in Foxpro -- is SQL the language used in these methods and events?!?!? I learned SQL from a book (new) 3 months ago, and the syntax looks nothing like what's being used here. Did I get bad info?
>>
>
>Yes VFP does support SQL. TableUpdate and TableRevert are foxpro functions not SQL. For more info look up SQL Commands Overview in the VFP help.
>
>And lookup TableUpdate and TableRevert in the help while you are there.
>
>>
>>>Sorry, ok. Did you replace 'MyTableName' with the name of your table? Is there any other code in the click event?
>>>
>>>>Don't know - it doesn't say.
>>>>
>>>>
>>>>>And that syntax error would be?????????????????????
>>>>>
>>>>>>When I use TableUpdate(1, .T., 'MyTableName') in the click event, I get a syntax error.
>>>>>>
>>>>>>
>>>>>>