Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tip: VFP Handling of Use ... NoData
Message
 
 
À
15/12/1999 17:44:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00304054
Message ID:
00304990
Vues:
23
Come to think of it, this was indeed with a local view. If there are no records returned for a remote view, an empty cursor is not created in VFP unless one already existed. So Michael's explanation on how remote views with NODATA are handled make sense.

If the where clause has 1=0 in it, how can that be optimizable? This is also starting to clue me in on a local view I have on a very large table when I open that view with NODATA. The view is parameterized and the parameter is indexed, but that view is very slow to open. Makes me think the 1=0 in the where clause is doing this. Now that I have the SQL VFP uses, I can test this.
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform