Dennis,
Wouldn't it be nice if, among SO MANY enhancements and bug-fixes, the upcoming In-line Patch-3 of The Glorious R:BASE 2000 (ver 6.5++) for Windows included RECALC VAR VarName to re-calculate one variable ONLY! Very Best Regards, Razzak. At 10:54 AM 9/5/2002 -0400, Dennis Fleming wrote: >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? ================================================ 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/
