HELP HyperScript/Wingz reply

In article 5646@sydney.DIALix.oz.au, nswdot@sydney.DIALix.oz.au (NSW Department of Transport) writes: >Applewogys to the net if you have seen this question before. > >We are trying to set up HyperScript Tools so that a user may click on an icon >in windows and be presented with a worksheet loaded with data from an informix >database, which they then may modify, report on etc. > >We have tried to do this a couple of ways: >1) - Write a script to set up datalink and load the worksheet. This works fine > when we load HyperScript Tools and run the script. However we can't get > HST to do that from the command line. If we run our script like this > hstools -hsruntime ourscript > HyperScript Tools runs loads the worksheet, but the only thing on the > menu bar is the "Hyperscript Tools" option that does nothing. > The user need to be able to work with the worksheet after the data is > loaded. If you use -hsruntime, HST assumes you are providing the user with a complete application ready for distribution that has its own interface. Since that is apparently not what you're doing, -hsruntime is not appropo. FYI, the -hsruntime option is so that you can simulate a runtime environment without actually having the runtime product. It simply makes it easier for you to develop a "runtimeable" app. > >2) - Place the script into "startup.scz". This almost works apart from a > error which is not discribed in our documentation (we are still > waiting on an answer from our support). > Anyway this does not seem like a good solution as we will need to load > many different worksheets and I don't look forward to having to maintain > 50 different scripts all named "startup.scz". This should work but as you've discerned is probably not the best way. How about this... ----------------------------------------------------------------------- Each sheet already exists. Drag the sheet icons from the FileMgr and drop them in the Program Mgr. They will all default to the HST icons but of course you can change that. The user can now click on any of these icons, open HST, and have the sheet on screen with the entire user interface. See your Windows manual if you have any questions on adding icons to the Program Mgr. Put an "ON OPEN" event in the worksheets. Here you can have HST get the data when the sheet is opened automatically. Alternatively, you might... ----------------------------------------------------------------------- Create a script that gets the data and puts it in a sheet. Use the icon info about. If you launch HST by clicking on the script icon, HST will launch & initialize then run the script. btw ----------------------------------------------------------------------- I'd switch to the built-in SQL in HST instead of DataLink. I think you will find it MUCH faster, easier to use, far more flexible, and easier to maintain. DataLink is obsolete. So ------------------------------------------------------------------------ I think this addresses the issues you've raised. Jim Std. Disclaimer - These are my opinions.