Handling more than 2 GB in a table.

[Gon Nadiya]

Hi all,

I want to download a table from the SQL Server to VFP 8 using SQLEXEC().
when I download some tabels I'm getting the error
"File C:\Document and setting\Admin~1\Locals~1\temp\f0W4002v.tmp is too
large. "

This is because the file I'm downloading is greater then 2 GB in size.
As I got to know VFP can handle tables only upto 2 GB.

Is there a way I can overcome this.

Nadee.

[Gerben Kessen]

<CINDY>
Hi Nadee,

You can find a way to split the table horizontally such as A-M and N-Z. You
can also split the table vertically so each file has the primary key and
some columns are in one table and the rest are in the other table.

You'll be interested in reading "The Ultimate Power & Speed of VFP
Handling Extremely Large Data Sets" ,
http://advisor.com/Articles.nsf/aid/MATIV02 .
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
***@mvps.org www.cindywinegarden.com
</CINDY>
_______________________________________________
<FRED>
You might be able to horizontally split the tables:

Split the SQL table into multiple VFP tables. Select just some of the
fields into the first table (including the ID field), select other fields
and the ID field, etc.

If that doesn't work, then pull all fields, but only for a smaller subset of
records, into as many tables as needed.

Fred
Microsoft Visual FoxPro MVP
</FRED>

Post by Gon Nadiya
Hi all,
I want to download a table from the SQL Server to VFP 8 using SQLEXEC().
when I download some tabels I'm getting the error
"File C:\Document and setting\Admin~1\Locals~1\temp\f0W4002v.tmp is too
large. "
This is because the file I'm downloading is greater then 2 GB in size.
As I got to know VFP can handle tables only upto 2 GB.
Is there a way I can overcome this.
Nadee.