Information générale
Catégorie:
Codage, syntaxe et commandes
>Is there an easy way to make a Grid display a SQL
>cursor???
>
>Tom
There is a trick in FoxPro Advisor April 1996 page 28 «Refresh
Grid.RecordSource» published by Drew Speedie that work fine.
The idea is to base a grid on a view, likely a parameterized one. When it's time to update the view:
=requery()
your grid and all the objects it contains remain INTACT; the displayd data changes.
Since view can only exist in VFP databases, create a temporary database, add the view, and delete everything when done:
*form load
create database temp
set database to temp
create sql view...
* the view is now available to the grid
*form unload
use in
close database temp
erase temp.dbc
erase temp.dcx
erase temp.dct
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