Dennis,
Could you put all the values you are calculating
into a view?
Then they would always be up to date when they are
displayed.
Randy Peterson
----- Original Message -----
From: "Dennis Fleming" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 05, 2002 10:54 AM
Subject: An easy one...??
> 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/
