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.
rk -----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Tuesday, July 07, 2009 1:21 PM To: profoxt...@leafe.com Subject: Re: How do you hold short term data? On Tue, Jul 7, 2009 at 11:59 AM, Richard Kaye<rk...@artfact.com> wrote: > Assuming you have a table with states, select <columns> from states into > <global array> at app startup. goShipping = container for your shipping standard data. Your FedEx and UPS #s, company shipping address etc. Can you do the select into goShipping.States? I didn't think so but I wasn't aware of VFP doing collections either until today. _______________________________________________ Post Messages to: ProFox@leafe.com 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/df1eef11e586a64fb54a97f22a8bd044056b8f7...@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.