Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating Cursor
Message
De
02/07/2003 09:35:48
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00806038
Message ID:
00806054
Vues:
19
Hi Neil,

>I would also like to add a second field named key 2 but I dont know how to incorporatye this into the above syntax.

>create cursor temp1 (key1 c(fsize('key1','result')))

You create fields as a comma separated list:
create cursor temp1 (key1 c(fsize('key1','result')), key2 <type> <size> )
Alternatively, if this is based on an existing table, you can use SQL to create the cursor for you:
SELECT key1, key2
  FROM result
 WHERE 0 = 1
 INTO CURSOR temp1 READWRITE NOFILTER
The trick here is to use a WHERE clause that will return no records - so all you get back is an empty structre.
----
Regards
Andy Kramek
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform