Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SKIP command: how to implement in SQL
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00116163
Message ID:
00116693
Vues:
14
>>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)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform