>I have a grid in my VFP 3.0 form that has a grid with a paramaterized local view as the
>data source, using optimistic table buffering. In a method on the form, I need to run a
>SQL-Select statement against this view to create another cursor, and I need the results
>to show the un-commited changes the user may have made to the grid. I have run the
>SQL statement against the name of the grid's view or against the DBF() of the
>grid's view, but both do NOT show the user's un-committed changes. I can loop
>through the local view and create a table with REPLACE, but I would rather use a
>SQL-Select statement. Any ideas?
I think you are out of luck using a SQL statement since it always uses the base tables. If all the data you need is in the existing view, try using COPY TO or create a new cursor and use APPEND FROM.
-Doug-
Précédent
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