Is there a way to export a FoxPro 2.x compatible table similar to:
USE MyTable
COPY TO OldFoxTable TYPE FOX2X
Printable View
Is there a way to export a FoxPro 2.x compatible table similar to:
USE MyTable
COPY TO OldFoxTable TYPE FOX2X
Hi,
You can use this:
Don't forget the set filetype to afterwards to reset the filetype!Code:use mytable
set filetype to foxpro
copy to oldfoxtable
set filetype to
Regards,
Yvonne
Thank you for the suggestion Yvonne.
Unfortunately, executing the code resulted in a crash (Lianja RC7 on Windows 7 64-bit) while exporting a table having the following structure: (X B(4) Y B(4))
Problem Event Name: APPCRASH
Application Name: lianja.exe
Application Version: 0.0.0.0
Application Timestamp: 51e8f608
Fault Module Name: librecital.dll
Fault Module Version: 10.0.2.0
Fault Module Timestamp: 51e91832
Exception Code: c0000005
Exception Offset: 002a94bf
OS Version: 6.1.7601.2.1.0.256.48
Locale ID: 1033
Another compatibility issue was revealed in the process, i.e. reading a FoxPro table containing "Floats". Should this be a separate thread?
* Execute the following in FoxPro 9.0:
CREATE TABLE fp9 (X F(16, 4), Y F(16, 4))
INSERT INTO fp9 (X, Y) VALUES (111.1111, 8.8888)
INSERT INTO fp9 (X, Y) VALUES (222.2222, 9.9999)
USE
* Execute the following from the Lianja console:
* Lianja appears to interpret the data in "Float" fields as having a value of zero.
USE fp9
BROWSE
USE
Note that Lianja interprets data in "Numeric" fields with the correct values. An examination of the DBF at a low level reveals the only difference between "Float" and "Numeric" fields is the letter representing the fields type, i.e. "F" for float and "N" for numeric. Maybe this will be an easy fix.
Hi,
The legacy set filetype functionality has not been disabled, but is not being actively supported or updated. If it is not working for a particular table, you will need to use one of the export options from COPY or SQL Select and then import.
Visual FoxPro tables should be imported into Lianja using the Import VFP database Database Option or Add... Tables Option in the Data Workspace (or just drag from Windows Explorer into the Tables area with an open Lianja database). If you have a problem importing a particular Visual FoxPro table, please Submit a ticket.
Thanks,
Yvonne
I just sent my old database in FOX PRO Lianja on it went flawlessly