Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT SQL with SKIP
Message
 
 
To
24/06/2004 03:43:23
Ignacio Amoros
Juguetes Pastor, S.L.
Altea, Spain
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00916329
Message ID:
00916752
Views:
13
It wouldn't work if you have more than 10 duplicate values or duplicates begin in the previous batch.

>Hi Sergey, I was think this, but in big tables the query is too slow, because the combination of this, not exist in any index expression. I think that the best option is send a cursor with unique field that be the primary key field, and the component convert this XML to cursor and compare this in subquery, for exclude this records of the next or previus query.
>
>Something as this:
>
>SELECT TOP 10 field1,field2,field3 FROM datos ;
> WHERE field3 NOT IN ;
> (SELECT field3 FROM curtemp) ;
> ORDER BY field1
>
>Do I explain well?
>
>Tks for your sugerencies
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform