Hi everyone,

I have a somewhat complicated form I'm working on here thats VFP6.0 connected to a SQL Server 7 backend. The form accesses several records in several different tables (remote views as far as the form is concerned). I am currently trying to use an optimistic table buffering scheme for this setup so that a tablerevert() on each table will undo all changes made during the life of the screen.

The question however, is how do I get around in these views that are table buffered quickly as Foxpro will not let me index the view when it is optimistic table buffered.

Is there an efficient way to do this? Right now its going to be some filters on that table to limit access to the records currently being edited, but I don't like filters much.

Is there something with transactions I can use?

Thanks alot.

Matt