Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL instructions as 'RowSource' for objects
Message
 
To
17/08/2000 21:24:26
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00406329
Message ID:
00406781
Views:
31
I am curious as to why you used the NOFILTER parameter? The VFP docs below indicate there is a performance hit and the temporayr table is not updateable per my test. You can close a cursor created with "SELECT * FROM myfile INTO CURSOR myquery" with "use in myquery".
If I am wrong, please advise.
Robert Baker

From VFP 6 help:
"Include NOFILTER to create a cursor that can be used in subsequent queries.....
Including NOFILTER can reduce query performance because a temporary table is created on disk. The temporary table is deleted from disk when the cursor is closed."


>>Here goes:
>>
>>When I use a SQL instruction as my RowSourceType (option #3) in a listbox and then set the RowSource property to a valid SQL query ('SELECT * FROM sales' for example), a browse window always pops when I run the form containing my listbox. Why is that and how can I change it?
>>
>>Thanks, Steph.
>
>Set it to "SELECT * FROM sales INTO CURSOR cuComboCursor NOFILTER"
Robert - Zxytek
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform