Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating Cursor
Message
From
02/07/2003 09:35:48
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00806038
Message ID:
00806054
Views:
18
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
Previous
Reply
Map
View

Click here to load this message in the networking platform