I think of it like inserting from a 'NAME' object. One record, many fields.
INSERT FROM NAME loxyz ----- Original Message ----- From: "Fred Taylor" <[email protected]> To: "ProFox Email List" <[email protected]> Sent: Thursday, June 23, 2011 11:07 AM Subject: Re: INSERT INTO MyCursor FROM ARRAY MyArray If you do have a multiple dimension array, you can get multiple records: CREATE CURSOR xfiles (filename C(50), filesize N(12,0), filedate D, filetime C(8), fileatts C(5)) ADIR(aDirFiles,"*.*") INSERT INTO xfiles FROM ARRAY aDirFiles BROWSE Fred On Thu, Jun 23, 2011 at 10:46 AM, MB Software Solutions, LLC < [email protected]> wrote: > On 6/23/2011 1:00 PM, Fred Taylor wrote: > > INSERT FROM ARRAY puts 1 element per field, not multiple records. > > > Aaah, so if I had an array 1 row by 15 columns, those 15 columns would > turn into 15 records in the insert-cursor? Not seeing a use for that > (although I'm sure there is one somewhere). > [excessive quoting removed by server] _______________________________________________ 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/03d901cc31de$e9710260$7a00a8c0@w2k3s02 ** 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.
