File to big????

[Rotsj]

Hi,
in vfp9 i want to append records from one file to another. I use the append
blank / replace method for this. There are 2.000.000 records to add. When i
try this, after a while i get the message file to big (or something like
that). When i look, my file is, indeed very big. When i first add 400k of
records, and pack the file, it's only 5k.
Do i have to add 200k at the time and keep packing? (It's very time
consuming) or is there a better method????

Thanks!

Rotsj

[Lee Mitchell]

Hi Rotsj:

What is the exact error message that you receive?

Have you tried adding a SYS(1104) before the APPEND BLANK and REPLACE
commands?
Have you tried adding a SYS(3050) to your code?

http://support.microsoft.com/default.aspx?scid=KB;EN-US;176483


I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

Post by Rotsj
Hi,
in vfp9 i want to append records from one file to another. I use the append
blank / replace method for this. There are 2.000.000 records to add. When i
try this, after a while i get the message file to big (or something like
that). When i look, my file is, indeed very big. When i first add 400k of
records, and pack the file, it's only 5k.
Do i have to add 200k at the time and keep packing? (It's very time
consuming) or is there a better method????
Thanks!
Rotsj

[Dan Freeman]

Without seeing some code it's impossible to say for sure but I'm confused
what the heck PACK has to do with appending records? Append/Replace, alone,
doesn't cause deleted records.

Having said that, append blank/replace hasn't been the preferred method for
moving blocks of records from one table to another for years. Have you tried
APPEND FROM?

Another alternative, since you're using VFP9, is:

Insert Into TargetTable Select * from SourceTable

Alter the SELECT input clause as needed to achieve the necessary structure.

I suspect you're really describing two or three overlapping problems. Can
you pick just one? <g>

Dan

Post by Rotsj
Hi,
in vfp9 i want to append records from one file to another. I use the
append blank / replace method for this. There are 2.000.000 records
to add. When i try this, after a while i get the message file to big
(or something like that). When i look, my file is, indeed very big.
When i first add 400k of records, and pack the file, it's only 5k.
Do i have to add 200k at the time and keep packing? (It's very time
consuming) or is there a better method????
Thanks!
Rotsj

[Anders]

If you're appending a bunch of deleted rows from another DBF:

SET DELETED ON
APPEND FROM bigtable.dbf

-Anders

Post by Rotsj
Hi,
in vfp9 i want to append records from one file to another. I use the append
blank / replace method for this. There are 2.000.000 records to add. When i
try this, after a while i get the message file to big (or something like
that). When i look, my file is, indeed very big. When i first add 400k of
records, and pack the file, it's only 5k.
Do i have to add 200k at the time and keep packing? (It's very time
consuming) or is there a better method????
Thanks!
Rotsj

[Rotsj]

Hi,
sorry for my late response but it turned out to be that the file really was
to big as it was more then 2G.

Rotsj

Post by Rotsj
Hi,
in vfp9 i want to append records from one file to another. I use the append
blank / replace method for this. There are 2.000.000 records to add. When i
try this, after a while i get the message file to big (or something like
that). When i look, my file is, indeed very big. When i first add 400k of
records, and pack the file, it's only 5k.
Do i have to add 200k at the time and keep packing? (It's very time
consuming) or is there a better method????
Thanks!
Rotsj