Results 1 to 5 of 5

Thread: Export FoxPro 2.x Compatible Table

  1. #1
    Junior Member
    Join Date
    Aug 2013
    Posts
    2

    Export FoxPro 2.x Compatible Table

    Is there a way to export a FoxPro 2.x compatible table similar to:

    USE MyTable
    COPY TO OldFoxTable TYPE FOX2X

  2. #2
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,831
    Hi,

    You can use this:

    Code:
    use mytable
    set filetype to foxpro
    copy to oldfoxtable
    set filetype to
    Don't forget the set filetype to afterwards to reset the filetype!

    Regards,

    Yvonne

  3. #3
    Junior Member
    Join Date
    Aug 2013
    Posts
    2
    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.

  4. #4
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,831
    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

  5. #5
    Junior Member
    Join Date
    Apr 2014
    Location
    Ivoiry coast
    Posts
    2

    Good

    I just sent my old database in FOX PRO Lianja on it went flawlessly

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us