Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursor
Message
 
 
À
10/11/2003 09:00:25
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Re: Cursor
Divers
Thread ID:
00848253
Message ID:
00848264
Vues:
15
>Here is my code
>
>
>select * from customer order by name into cursor temp
>
>
>
>After that i want to use the function seek()
>
>
>it is possible or how can i do that thanks

Robert,
To use Seek(), you need an index. You can create one on the temporary cursor.

This leads to the question of why you want to do this. The example you gave is simply selecting all records from customer into a temporary cursor. You then want to do a seek within the temp cursor. Why?

Can't you do a seek on the Customer table itself? Can't you specify the sekk criteria in the SELECT statement instead? That way, the temp cursor will already have the records that match the seek.

Regards.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform