Re: output section

In article <2i2u9aINN67n@emory.mathcs.emory.edu> bt@irl3b2c.att.com writes: > In response to Brian London's query > > >>Fellow sqler's and 4gler's, > >> > >>If this is a trivial question forgive me but.... > >> > >>Is there a way to "variablize" the report to statement so a user can input > >>the destination, in either 4gl or ace reports. So far the only solution I > > > Jonathan Leffler wrote: > 4GL Stuff deleted. > > Nice one, Jonathan, but can you do something similar in ACE? My solution has > been *always* to send to a file, then use a UNIX script to ask the user where > he wants the report to go. Have you a more elegant solution? > There is another route. I have a similar problem as I wish to use one ace report against a number of different, although similarly named tables, all in the same database. My solution was to get hexed, a public domain binary file editor, and write a script to patch the .arc, before running it. I'm sure you could do the same to patch the destination. It seems to me there are two other options. 1) Wrap the ace in a perl or shell scripts, to capture stdout and put it wherever you want to. 2) Use isqlperl as an alternative to ace! > > ** Opinions expressed are my own and not necessarily those of my employer > ========================================================================= > Barry Toomey Phone +353-1-2822333 > AT&T Network Systems Ireland Fax +353-1-2822864 > Corke Abbey Avenue, email: bt@irl3b2c.att.comm > Bray, uunet: att!irl3b2c!bt > Co. Dublin > Ireland > ========================================================================= > -- Clive Eisen Email ceisen@deepthwt.demon.co.uk Clive Eisen Computing Phone (+44) 71 281 1414