-
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
-
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
-
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
-
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
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|