Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rushmore Optimization - Or so I thought!
Message
 
 
À
31/10/2003 18:37:30
Todd Cottengim
Alpine Land Information Services
Redding, Californie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00845268
Message ID:
00845274
Vues:
12
In your test, how many records in imsfilter? How many records are selected into cursor? Try with one record in imsfilter and post result returned by SYS(3054) in each case.
LOCAL cmemvar
=SYS(3054,11,"cmemvar")
SELECT ...
_CLIPTEXT = cmemvar
>>You can try
>>* JOIN
>>SELECT cr.plot_id ;
>>	FROM crzplots cr ;
>>	JOIN  imsfilter ON linkfield = cr.plot_id ;
>>	INTO CURSOR cPlots
>>
>>* Correlated subquery
>>SELECT plot_id ;
>>	FROM crzplots ;
>>	WHERE EXISTS (SELECT *  FROM imsfilter WHERE linkfield = plot_id) ;
>>	INTO CURSOR cPlots
>
>
>Tried both. Both still return SYS(3054) of "none" for both tables.
>
>Any other thoughts.
>
>TC
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform