Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SKIP command: how to implement in SQL
Message
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00116163
Message ID:
00116693
Views:
15
>>Thanks in advance for any suggestion
>
>You could use TOP clause of SQL:
>
>

>currentkey = crsr.key
>SELECT TOP 1 * FROM table WHERE table.key>currentkey INTO CURSOR crsr
>
>
>this works for next record and use < for previous record.
>
><\PRE>

Thanks to all for your ideas,
In this weekend I've thought to something like to Fred's suggestion.
Can you tell mes something about no-batch mode to have the SQL results usign the SQLMORERESULT(), doesn't it seem like to skip record by record ?

Thanks
Renato Bertuol (EMail:renato.bertuol@elmec.it
Homepage:www.geocities.com/SiliconValley/Horizon/3216)
Elmec Informatica (URL www.elmec.it)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform