>I was afraid most of the people use tableUpdate(), but what
>do you do when you have to go trough the table to check
>for some information before you add-update the record? If you
>move the record pointer then changes are updated and you loose
>some of the advantages.
>
>I'm a bit lost in this matter. Thanks for your advice.
>Javier Borrajo.
I want to tell what is my approach is:
1. Buffering is a great thing and should be used.
2. Working with Grid control we must specify recordsource and so must be 'buffer-oriented' handling data.
3. For any other control we must not specify control source therefore we just allow user to fill some information (into textboxes,comboboxes, etc.) and then in e.g. cmdSave.click (collect conrol Value(s)) do tableupdate() and check data integrity by error trapping (referential integrity must be enforced).
I strongly believe that referential integrity and right indexing more important thing than buffering.
Edward Pikman
Independent Consultant