>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.

Matt, I ran into the same problem and I wanted to create indexes on the fly also (so if the user didn't need a particular index, I didn't create it).

What I did is do a CURSORSETPROP. You can index a view in row buffering mode. Something Like this.

CURSORSETPROP("buffering", 3, "somealias") && put the view in row buffering.

INDEX ON xyz_field TAG xyz_tag
SET ORDER TO zyx_tag

CURSORSETPROP("buffering", 5, "somealias") && put it back in table buffering.

Of course, this requires there to be no updated records in the view when you do this.

Hope that gives you an idea.

Rob.