Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
RECNO()
Message
De
02/02/2001 15:50:48
 
 
À
30/01/2001 10:42:09
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00464929
Message ID:
00471978
Vues:
30
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
Fil
Voir

Click here to load this message in the networking platform