It is a text file. It comes from a mainframe via DYNAM cartridge. I have no control over how large it is. And I know of no tool that can split it properly (at a linefeed). It is data for a quarterly update for a SQL Server 6.5 database. I am using Fox to do the QC and preprocessing. It get larger every quarter and has finally surpassed the 2 GB threshold.
A FEOF() returns .T. I have not tried a FSEEK. I'll have to get back to you on that.
Bob
>Is this a text file? My text files have gotten pretty big, but never over 2GB! WHat Fox users have recommended over the years for large tables over 2GB is to create smaller tables, and create a relationship between them.
>
>Your gonna be using FGETS to pull in data from the file? Does it hang up if you just keep pulling data out line by line?
>
>I presume you've tried
FSEEK(gnFileHandle, 0, 2) to determine the EOF?
>
>If it's just a dumb text file your extracting data from, certainly you could split it into several smaller files and tackle the one at a time in code?
>
>>Has anyone done an FOPEN and FEOF on a file that is larger than 2.1 GB? I seem to be able to do the FOPEN, but the FEOF returns .T.
>>
>>Regards, Bob
Database Development Team