Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating empty cursor using SQLEXEC()
Message
From
23/07/2003 07:54:31
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
 
 
To
23/07/2003 07:46:41
Alan Harris-Reid
Baseline Data Services
Devon, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00812705
Message ID:
00812709
Views:
12
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform