Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor and append
Message
From
03/07/1997 10:21:31
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
28/06/1997 18:39:23
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00037995
Message ID:
00038510
Views:
35
> 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.
Previous
Reply
Map
View

Click here to load this message in the networking platform