>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement