Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rushmore Optimization - Or so I thought!
Message
 
 
To
31/10/2003 18:37:30
Todd Cottengim
Alpine Land Information Services
Redding, California, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00845268
Message ID:
00845274
Views:
11
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform