IIRC good ol' XBASE APPEND FROM will do column matching for you whereas using SQL INSERT INTO ... SELECT will give you agita fi you try using * instead of explicit columns. Which also means you have to include any required columns that don't support NULLs even if that data is not in the source of the SELECT.
-- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of MB Software Solutions General Account Sent: Friday, July 12, 2013 11:08 AM To: [email protected] Subject: RE: Why can't I ALTER TABLE on a cursor? Vince -- for some reason, I was thinking that APPEND FROM MyCursor (into my real, permanent target table and without using the FIELDS clause) had to match up for columns, but I guess I was wrong. More testing today. _______________________________________________ Post Messages to: [email protected] 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/DF1EEF11E586A64FB54A97F22A8BD0442284263BD3@ACKBWDDQH1.artfact.local ** 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.
