You could alter your vfp table and add a column called PK, fill it with recno() and index it. Now you have your PK. You could also split the big file in reasonably sized chunks as suggested and do the above. It would be much faster
Rafael Copquin El 22/02/2012 02:30 p.m., MB Software Solutions, LLC escribió: > On 2/22/2012 2:24 AM, AndyD wrote: >> llfs in Fox is *fast* - and very flexible - that's the way I'd go. Read >> in a chunk, take a substring up to the last whole record, work with that >> then read on from that offset, rinse& repeat. >> >> "Here's a potential gotcha...there's no clearly defined PK for these rows." >> Write-only storage then?<g> > > Well I was thinking that I wouldn't be able to use Remote Views because > I wouldn't be able to define a PK. I guess I'd have to make the entire > set of fields the PK? > > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
