Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inserting from a Cursor into an external .dbf
Message
From
06/04/2004 11:36:09
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
06/04/2004 11:31:39
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00892627
Message ID:
00892631
Views:
17
>Hello,
>I have an application where I populate a cursor. The cursor has the same structure as c:\transact.dbf. What I want to do is append the contents of my cursor onto the end of the c:\transact.dbf. I looked into the insert into query but it seemed like all I could use was memvar. I am confused!!
>
>Thanks!!!
>
>MAC

You can't do it in a single step; I think this will be supported in VFP 9.

In earlier versions, it could go something like this:
select from SomeTable into table TempTable where ...
* if the cursor already exists:
* select SomeCursor
* copy to TempTable
use transact.dbf
append from TempTable
erase TempTable.dbf
HTH,

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform