An enhacement to our app Main Menu (using the glorious 6.5++) is to show a summary of all pertinent plant info. The question is, what's the best way to "refresh" this data. I thought about doing it at startup, and then again when a Refresh button is pressed, but it would really slow things down since a huge chunk of the data base is read to build the summary. So..
It seems a bit clumsy, but I ended up with all the values stored in a table and then "looked up" on the main menu screen form. The Refresh button (to update the summary table) is a Supervisor only function since a couple of updates a day is plenty. But, Select Count (*) into varname1 FROM tablename Where clause ... won't work if I have multiple varnames which I want to load from the same table using Different where clauses (unless I'm missing something). Performance-wise is there much of a hit here with loading varnames separately (for the same table) versus doing a bunch in the same Select command? TIA, Dennis ***** Dennis Fleming IISCO http://www.TheBestCMMS.com Phone: 570 775-7593 Fax: 570 775-9797 ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
