Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

export from command line to dBaseIV?

Status
Not open for further replies.

pawel

Instructor
Nov 11, 2000
1
SE
I'm writing an application and cannot find the correct command to export file from visual foxpro3.0 to dbaseIV. Please help me with the correct command.
Thanks
 
Try first:

[tt]copy to MyDbase type foxplus[/tt]

I think dBaseIV should be able to read that, although if there are memo fields it might be dicey. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br> [/sig]
 
If the database has a memo field in it, do not forget:

SET COMPATIBLE FOXPLUS | OFF | DB4 | ON [PROMPT | NOPROMPT]
Controls compatibility with Microsoft FoxBASE+ and other Xbase languages.
Arguments

FOXPLUS | OFF
(Default) These two keywords can be used interchangeably. Each allows programs created in FoxBASE+ to run in Microsoft Visual FoxPro without changes.

DB4 | ON
These two keywords can be used interchangeably. Including either keyword affects the behavior of the commands and functions listed below.

PROMPT | NOPROMPT
These options determine whether Visual FoxPro displays a dialog box when you open a dBASE table containing a memo field.

Include the PROMPT option to display the Convert Memos dialog box. If you open a dBASE table containing a memo field, Visual FoxPro by default displays the Convert Memos dialog box, which enables you to convert the dBASE memo file to a Visual FoxPro format. You must convert the memo file to a Visual FoxPro format to open the table in Visual FoxPro. You can later convert the memo file to a dBASE format by including the TYPE FOXPLUS option in the COPY command.

If you include NOPROMPT, the Convert Memos dialog box is not displayed when you open a dBASE table containing a memo field. The dBASE memo file is automatically converted to a Visual FoxPro format.

[sig]<p>David W. Grewe<br><a href=mailto:Dave@internationalbid.net>Dave@internationalbid.net</a><br>[/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top