I have never needed to use SCATTER and GATHER before. I have a couple of questions about them.

Can SCATTER MEMVAR follow the SELECT mytable command?

If I have a form with Add/Save and an Edit/Cancel button,
can I put GATHER MEMVAR inside the Save code and leave it out of the Cancel code. When I press Add or Edit buttons, they change to Save and Cancel buttons.

I ran a test and Added a new record to my table after pressing the Save button, but when I Edited the record and pressed Cancel to destroy or revert my changes, the changes saved anyway.

Does this mean that I can't have a ControlSource for mytable any more, if I am using SCATTER and GATHER? I am a bit confused as to how to work the Cancel button (revert changes) when it comes to GATHER.

I assumed I didn't put GATHER MEMVAR and the changes would not be saved, but they were.

Please help. I was using table buffering and did TABLEUPDATE and TABLEREVERT, but the client wants me to use SCATTER and GATHER instead because we are getting too many "table buffer" errors using table buffering.