richard
12th March 2003, 10:42
We have several querys with the same report (and report-script).
Is there a possibility to know which query is used (variable ?) within the report-script ?
Regards
lbencic
12th March 2003, 17:11
I can't find a variable for query name. doesn't mean there is not one..
Try the variables prog.name$ and procesinfo$ for some clues. I don't know what you would see for them in report debug mode for a query though.
richard
12th March 2003, 17:26
prog.name$ = report code (rtisqlu1inf1544)
procesinfo$ = empty
I think the best way is a simple session with extern variables.
Thank's
lsilvag
12th March 2003, 19:06
You need to compile the report on debug mode, then put a break or just stop the report on the last layout. In this point you can type on the debug screen "Lp" and redirect the output to display or ASCII file wherever you want. You will see all the variables available on the process including the variables responsible for queries.
P.S. I use this method all timeĀ