Kevin Cully wrote: > Just to tack on some more Foxpro talk, I prefer to use the SCATTER NAME > / INSERT FROM NAME methodology, as a way of getting away from APPEND > BLANK. If the GATHER fails for whatever reason, many times you're left > with a record that blocks the next APPEND BLANK. > > SELECT table2 > SCATTER NAME loMyRecord FIELDS EXCEPT Voucher > INSERT INTO table1 FROM NAME loMyRecord
Holy cow - 12 years with Foxpro and I'm STILL learning new things! Great tip, Kevin - can't wait to try it! _______________________________________________ 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.
