Ephen, Yes that is one of the great thing about collections you can wrap them up into elements within other collections.
As I said, it really takes a while to get your head around the best way to access elements in multi level scenarios but once you do that it is easy. Start with a simple collection first and then expand it using the debugger to find out the best ways to lay out your data. It's time well spent and the nice thing is you can traverse collections using the "for each <> in...." construction. Dave Crozier -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Russell Sent: 07 July 2009 21:06 To: ProFox Email List Subject: Re: How do you hold short term data? On Tue, Jul 7, 2009 at 1:53 PM, Richard Kaye<[email protected]> wrote: > If goShipping.States is an array property, yes. (SELECT INTO... ARRAY goes back a ways...) If it's a collection, you would want to use a scan..endscan loop to populate it from your lookup table. > -------------------------- Got it. Can collections have collections within? Like CustomerStatement needs a collection of Invoices, that needs a collection of N line items. I assume so but I don't deal with it these days. -- Stephen Russell Sr. Production Systems Programmer SQL Server DBA Web and Winform Development Independent Contractor Memphis TN 901.246-0159 [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/b2633bbc1d2c43f68e0dc7cae0282...@develop ** 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.
