Whil Hentzen wrote a spiffy little ebook on using SQLite for exactly this purpose, pulling in large text files and then parsing out the parts needed into a VFP app. [Full disclosure: I edited some of the text, so I'm due exactly 0% of the massive royalties I'm sure he's making.]
http://www.hentzenwerke.com/catalog/sqlite2gb.htm On Wed, Nov 6, 2013 at 1:49 PM, Fred Taylor <fbtay...@gmail.com> wrote: > I've not tried to actually open and spin through a file larger than 2GB, > but I don't think it will work. Once the internal 32 bit pointer exceeds > it's limit, you're probably not going to retrieve the data you think you're > getting as it will now be a negative number. > > YMMV > > Fred > > > On Wed, Nov 6, 2013 at 11:35 AM, MB Software Solutions General Account < > mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > > > A provider has decided to give us everything in 4 large behemouth files > > now instead of by groups as they had in the past. This pushes the text > > files for this parsing program beyond 2GB. I thought VFP would choke > > immediately on them but it gets the handle just fine, and I did a > -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4tf-dmy-48pe_dv1zb9r5jk5b2toygr7qcudph9ndn...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.