General information
Category:
Coding, syntax & commands
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only