Re: USER in ace reports

A possible solution to this problem is to use a two stage report. In stage 1 do the selects and PIPE the results to a unix script which in turn will send them to a file with a name generated fron the USER login id. Then for the second stage write the report to use the file as input rather than the SELECT statement. It may be unnecessary to have a file named from the user login id as the outpur fro stage 1 would be put to that user's current directory. Malcolm Weallans Online Database Consultancy > In an ace report I have two select statements joined by a UNION and the > results going into a temp table. I would like to use a variable name > for the temp table being used in order to avoid problems with other > users attempting to use the same report. What I would like to do is use > the user name as part of the temp table name. > > How can I get this accomplished??? > > -------------------- ***** JBT ***** ------------------ > > > J. B. Taylor (jbtaylor@lanmail.rmc.com) > Reynolds Metals Company > Manufacturing Technology Laboratory > 3326 East 2nd Street > Muscle Shoals, AL 35661-1258 > FAX: 205-386-9656 > Voice: 205-386-9658 > > -------------------------------------------------------