On Tue, Jul 7, 2009 at 10:22 AM, Peter Cushing<pcush...@whisperingsmith.com> wrote: > Stephen Russell wrote: >> Question is about what do you do your short term storage of data in >> while working on a form? >> >> So you put everything into cursors or do you use arrays, xml makes no >> sense, or is there another storage that I am forgetting because this >> is the first cup of coffee? >> >> > I use cursors like everyone else but also form level variables for > things like what mode the form is in, flags for if anything has changed > and other odd bits of data. > I also have app wide global variables like user name, email address, > department, security level etc which are handy to have available any time. > ----------------------------
So you use collections for your "global vars" where they are packaged into a single object and you can ref them by name, right? Can you pump a small cursor into a collection? I am getting at a list of States in shipping. Why would you keep hitting the table for the same non changing data 1500 times a day? -- Stephen Russell Sr. Production Systems Programmer SQL Server DBA Web and Winform Development Independent Contractor Memphis TN 901.246-0159 _______________________________________________ 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/c4313dbe0907070831k5c73178dl6ec12e1080912...@mail.gmail.com ** 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.