Is it possible to run SQRs in TOAD. Right now I use UltraEdit.
Thanks.
The Make/Strip code might be able to work for SQR’s. I’ve tried
building it myself, but I don’t know enough about Peoplesoft to
successfully build a valid template. Here’s what I came up with so
far…
Don’t laugh…or not too loud!
{ Comments section:
Use the following variables to create your own template:
%SqlVar% - variable that receives the sql text
%SqlLength% - sql text length (for string declarations)
%SqlText% - first line of sql text
%SqlTextNext% - subsequent lines of sql text
For the best results, it’s recommended that the
%SqlTextNext% variable be included on a separate line.
Example: Delphi
%SqlVar% : string = ‘%SqlText%’ +
‘%SqlTextNext%’ +
;
}
begin-%SqlText%
%SqlTextNext%
end-select
end-procedure
If you are talking about SQR formerly owned by BRIO, then by Hyperion and now by
I believe Oracle which is a “report generation” system then I would
very much be interested in seeing the active SQR code which starts BEGIN_SELECT
and then gets very weird turned into a SELECT statement.
Often someone comes and says my program has problems, but when I say turn it
into a SELECT and I will have a look at it they groan because it requires a fair
amount of work.
