On 8/9/2011 1:47 PM, Jarvis, Matthew wrote: > Is speed a big issue with this processing? > > Maybe another work around might be to import into a table and process it > that way instead... > > I hear VFP does tables pretty well...<g>
It's actually doing that. A local cursor is created with the intended final structures. (There are 3 record types in the source flat file.) ALINES to get the word "lines" array of the entire file contents, then a cycle through each line, using a SCATTER on the target cursor, then setting properties (which are fields in the output cursor) via SUBSTR(..) parsing of the input text line, then INSERT INTO MyCursor FROM NAME MyObject. And no, speed isn't as important here as getting it to work! :-) I even tried it on a 3.5GB RAM laptop and it failed. I'm gonna have to step through it and find out what the heck is going wrong. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ 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.
