Information générale
Titre:
Recommendations please re: best data access method.
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
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