dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: More than 2 gb. table

  1. #1
    fr Guest

    More than 2 gb. table



    Due to VFP dbf limitation of 2.0 gb I cannot open a table full of "history
    transactions records". I need to work with it and "break" it down into several
    manageable tables.
    Any ideas of how to open or split the table even if some data is lost.

    Thanks

  2. #2
    Nancy Folsom Guest

    Re: More than 2 gb. table

    A series of archive tables?

    "fr" <agromat.ramirez@codetel.net.do> wrote in message
    news:3981e2ed$1@news.devx.com...
    >
    >
    > Due to VFP dbf limitation of 2.0 gb I cannot open a table full of "history
    > transactions records". I need to work with it and "break" it down into

    several
    > manageable tables.
    > Any ideas of how to open or split the table even if some data is lost.
    >
    > Thanks




  3. #3
    Fred - Armoni Guest

    Re: More than 2 gb. table

    fr (?)

    If you can't open the dbf anymore, you can deal with low level file (maybe, i
    don't know the limit).

    isolate the header of the dbf (the desciption of dbf files is in the help of fox)
    and knowing the length of a record (hope you know) without forget the deletion
    marker, you can read them one by one...

    HTH


    fr a écrit :

    > Due to VFP dbf limitation of 2.0 gb I cannot open a table full of "history
    > transactions records". I need to work with it and "break" it down into several
    > manageable tables.
    > Any ideas of how to open or split the table even if some data is lost.
    >
    > Thanks


    --
    Fred - Armoni (France) - FE AVP&Cie
    Département Français, La Rochelle



  4. #4
    Fred Taylor Guest

    Re: More than 2 gb. table

    If you're table doesn't have memo fields (or you don't care about them), you
    should be able to open the table with a hex editor, remove the header info,
    and save it under a new name. Now, you can cut this resultant file into as
    many pieces as you need since it's essentially now just a text file of fixed
    length records.

    --
    Fred


    "fr" <agromat.ramirez@codetel.net.do> wrote in message
    news:3981e2ed$1@news.devx.com...
    >
    >
    > Due to VFP dbf limitation of 2.0 gb I cannot open a table full of "history
    > transactions records". I need to work with it and "break" it down into

    several
    > manageable tables.
    > Any ideas of how to open or split the table even if some data is lost.
    >
    > Thanks




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center