General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Creating empty cursor using SQLEXEC()
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only