Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RECNO()
Message
From
02/02/2001 15:50:48
 
 
To
30/01/2001 10:42:09
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00464929
Message ID:
00471978
Views:
29
Hi Mike,
Oops, I forgot that I can't use left and right pointy brackets in message text. Ok, let's try that solution again, substituting quotes for brackets:

1. use AFIELDS() to get the structure of the input cursor into array1
2. create array2 which is a copy of the array created in step1. Modify the column names as required in array2.
3. create an SQL INSERT statement from array1 and array2--like this:

INSERT INTO "output cursor" ("output column name 1") VALUES ("input column name1")

but of course add all the columns and their respective input and output names
4. create empty output cursor using data in array2
5. scan input cursor, for each record, create 1 record in the output cursor using the INSERT INTO statement created in step 3.

If any questions, just holler.
Regards, Chaim
Previous
Reply
Map
View

Click here to load this message in the networking platform