Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating empty cursor using SQLEXEC()
Message
De
23/07/2003 07:54:31
Dorin Vasilescu
ALL Trans Romania
Arad, Roumanie
 
 
À
23/07/2003 07:46:41
Alan Harris-Reid
Baseline Data Services
Devon, Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00812705
Message ID:
00812709
Vues:
13
You can use CREATE CURSOR command in LOAD event to build a temporary cursor with the same structure until you issue SQLEXEC and refresh it with data.

Dorin

>I have a grid on a form which is populated via. a cursor created via. a SQLEXEC() statement. When the grid is first displayed, I want the cursor to be present (so the grid can find the recordsource) but empty until the user performs a query (ie. the equivalent of cursor.noDataOnLoad=.T. if I had dragged a remote view from a .dbc into the form's dataenvironment). The most efficient way I can think of is to create the empty cursor is to run the SQLEXEC() in form.load with a WHERE .F. filter clause. Is there a faster/better way to achieve minium form instantiation time?
>
>Any help would be appreciated.
>
>Alan
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform