Re: Dynamically Changing Graphics

->Subject: Dynamically Changing Graphics ->Date: Thu, 07 Jul 94 09:00:24 GMT ->From: greg@gsesco.DIALix.oz.au (Greg Wake) ->Organization: Geographe Software Engineering ->To: informix-list@rmy.emory.edu -> ->I have a number of PC's running over a TCP/IP Network to a Unix ->box running Informix. I also have Q+E and Inet V5.01 to provide ->access to the database from within my Windows Applications. -> ->Using this facility through Microsoft EXCEL is absolutely excellent ->given the graph capabilities of EXCEL. ( I am sure that the other ->popular spreadsheets are just as good!! :-) ) -> ->My question is, after retrieving data into my spreadsheet from ->a SQL Query, can I have that spreadsheet automatically update ->the data as it changes in the Informix Database?? -> ->Currently, a snapshot of the database is basically what you get ->and only changes when you re-execute the query. However, wouldn't ->it be nice to have a graph automatically changing in tune with the ->data as it is entered into the Informix Database?? -> ->Any suggestion as to either how can I do this??, OR, is there a ->product which does do this and if so, what would the impact on ->performance be?? -> ->Any help would be greatly appreciated. ->-- ->********************************************************************** ->Greg Wake Geographe Software Engineering -> Bunbury 6230 ->greg@gsesco.DIALix.oz.au Western Australia -> Greg, EXCEL has a powerful scripting language. Older versions of EXCEL had a macro type language, newer versions use a type of embedded BASIC. You might consider using a script to periodically retrieve the data and regenerate your graph. Since performance is an issue, you might have the script lengthen or shorten the time between queries depending on whether any data changed. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, SLS | / \\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\