Anthony: I implemented this in our menu structure by using our standard TCL shell program (the usual tcl stacker program). So, before I actually run the wIntegrate call I automatically exit the menu to our TCL shell. Then the query is run.
When it's finished the user is back at the shell with whatever restrictions they own (if restricted then anything they press returns them to the menu). If I just execute the following code (as a separate cataloged program from within a BASIC menu program): * ** Run process to start wIntegrate script SCRIPT = 'Chain "query\query.wis"' ; * path that contains the qb script CALL WIN.COMSUB(SCRIPT) EXECUTE \WIN.SERVER\ I get the query builder screen and the report and I'm returned to the menu instead of viewing the last page (which is why I route everything through the TCL shell). Hope this helps. Bill > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Anthony > Dzikiewicz > Sent: Thursday, December 16, 2004 12:16 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] wIntegrate (on Universe) Question > > > Yeah WIN.SERVER is good. > If you are at a command prompt all of this works just peachy. > However, when > you try this from menu it times out. It times out ONLY when you choose to > see the report in the report viewer. Otherwise, all is fine. WIntegrate > works fine here for anything I do. It seems like a great > product. The only > problem I have is that our users all login and get their menus. NO ONE is > allowed to break out of a menu to the command line. WIntegrate > doesn't like > this. It seems that it wasn't designed to do so. > > I do have a 'pseudo command interpreter' that I wrote for those occasions > where someone must break out for whatever emergency. I could program this > to allow WIN.SERVER. My preference is to have this work for users without > breaking out of a menu. > > Are you doing this at your place Bill ? Is your suggestion something that > you have working at your place ? If so, then I must be doing something > wrong. > > Anthony > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. > Sent: Thursday, December 16, 2004 12:51 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] wIntegrate (on Universe) Question > > Have you cataloged the WIN.PROGS in the local account? WIN.SERVER must be > able to be executed for the query. > > Bill > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Anthony > > Dzikiewicz > > Sent: Thursday, December 16, 2004 6:57 AM > > To: [EMAIL PROTECTED] > > Subject: RE: [U2] wIntegrate (on Universe) Question > > > > > > Ive just tried this and I get the same result. I created the program as > > suggested and put it on a menu. When you choose that menu > > option, the query > > builder pops up. However, right after you set up the query and > press ok, > > you are at a 'press any key to continue' on the menu (Universe machine). > > Meanwhile there is a wIntegrate window trying to pass the data to > > the report > > viewer and it times out. > > > > Anthony > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. > > Sent: Wednesday, December 15, 2004 2:28 PM > > To: [EMAIL PROTECTED] > > Subject: RE: [U2] wIntegrate (on Universe) Question > > > > Anthony: > > > > Try the following: > > > > ** Run process to start wIntegrate script > > SCRIPT = 'Chain "query\query.wis"' ; * path that contains the qb script > > CALL WIN.COMSUB(SCRIPT) > > EXECUTE \WIN.SERVER\ > > > > This will pop open the Query Builder from a BASIC program and you > > should be > > able to do what's necessary from there. > > > > Hope this helps. > > > > Bill > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] Behalf Of Anthony > > > Dzikiewicz > > > Sent: Wednesday, December 15, 2004 9:06 AM > > > To: [EMAIL PROTECTED] > > > Subject: [U2] wIntegrate (on Universe) Question > > > > > > > > > I forget if there is a separate group for this product. If so, sorry. > > > However, my problem is this; > > > > > > I am evaluating the wIntegrate product. One of the uses that > > we have for > > > this is the query builder/report viewer. We have a person who used to > > > tinker at the command line. We have long since pulled the plug > > > on this kind > > > of thing, because they did some 'bad things'. However, it is > > nice to let > > > them have the ability to query the data (after all it is > > theirs). So, it > > > seems wIntegrate can do this for us. My problem is that you need > > > to be at a > > > command line to allow wIntegrate to operate. So, we're back to > > > square one - > > > user at the command line. > > > > > > Our system is based on standard Universe menus. Is there a > way to add a > > > menu option (or create a VOC) that will allow the user to 'mess' > > > with query > > > builder, etc ? I have tried adding WIN.SERVER as a menu option. > > > However, > > > this half works. I created a simple query and tried to put it to > > > the report > > > writer and it times out, because the WIN.SERVER closes. If I > > > send it to the > > > screen, it works ok. > > > > > > Any workarounds to this ? > > > > > > Anthony > > > ------- > > > u2-users mailing list > > > [EMAIL PROTECTED] > > > To unsubscribe please visit http://listserver.u2ug.org/ > > ------- > > u2-users mailing list > > [EMAIL PROTECTED] > > To unsubscribe please visit http://listserver.u2ug.org/ > > ------- > > u2-users mailing list > > [EMAIL PROTECTED] > > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
