Information générale
Catégorie:
Codage, syntaxe et commandes
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement