Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL instructions as 'RowSource' for objects
Message
 
À
17/08/2000 21:24:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00406329
Message ID:
00406781
Vues:
32
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform