Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursor and append
Message
De
03/07/1997 10:21:31
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
28/06/1997 18:39:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00037995
Message ID:
00038510
Vues:
37
> In my program I need to append several tables (cursors?) to a table > (cursor) is this possible to do? > Is there some other func. witch does the same, with cursors? > > Best regards > > Per Simmersholm You simply Append From, but there is a little trick - append statement expects a filename, not an alias, so if you have sele * from a_table into curs tmp sele b_table appe from tmp you get an error "tmp.dbf does not exist" or something like that. You have to appe from (dbf("tmp")) this way you get the real filename of the cursor in a name expression, and give it to the append statement. Rules for append still apply - only the fields with matching names will be appended, the others will be blank, and you'd be surprised how much of string to numeric (not sure of this) or vice versa (this sure works) conversion is done automatically.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform