|
Home > Archive > FoxPro database connector > November 2005 > File to big????
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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 2005-10-27, 5:30 pm |
| 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/defaul...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/i...cid=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
>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 2005-10-27, 5:30 pm |
| 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
Rotsj wrote:
> 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 2005-10-27, 5:30 pm |
| If you're appending a bunch of deleted rows from another DBF:
SET DELETED ON
APPEND FROM bigtable.dbf
-Anders
"Rotsj" <r.knipscheer@home.nl> skrev i meddelandet
news:djrebp$jr9$1@ne
ws1.zwoll1.ov.home.nl...
> 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
>
>
| |
|
| 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
"Rotsj" <r.knipscheer@home.nl> schreef in bericht
news:djrebp$jr9$1@ne
ws1.zwoll1.ov.home.nl...
> 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
>
>
|
|
|
|
|