LIST option(? that creates the source code (OpenInsight 32-bit)
At 29 JUL 2022 07:24:09PM Barry Stevens wrote:
What is the LIST option(? that creates the source code for the list statement. Too many years have passed since last did this and cant see in documentation.
At 30 JUL 2022 05:15AM Andrew McAuley wrote:
Not at my computer, but it is S or X
World leaders in all things RevSoft
At 30 JUL 2022 02:16PM Dave Sigafoos wrote:
if it is still there it would be the X option
At 31 JUL 2022 05:31PM Barry Stevens wrote:
if it is still there it would be the X option
X was my first go-to.
Both S or X are not accepted.
I think I must have done it in AREV
At 01 AUG 2022 08:18AM Andrew McAuley wrote:
It used to be possible in OI - I have an RLIST_OUT record in my SYSOBJ.
World leaders in all things RevSoft
At 01 AUG 2022 10:31AM Aaron Kaplan wrote:
What is the LIST option(? that creates the source code for the list statement. Too many years have passed since last did this and cant see in documentation.
Cut and paste from the HELP file on RLIST rouitine. See DEBUG_FLAG
RList routine
Description
The processing module for OpenList queries RList takes the OpenList statement. The Report Designer uses RList to access data for queries.
Syntax
RList(statement, target, targetname, userarg, debugflag)
Parameters
The Rlist routine has the following parameters.
Parameter
Description
Statement
TheOpenList statement to process.
Target
If statement is a List statement, target is TARGET_PRINTER by default.
If statement is a Select statement, target is TARGET_SAVELIST by default.
TargetName
If Target is TARGET_CALLBACK$ then targetName is the name of the callback function. If targetName is null or invalid, a loading error will occur.
If Target is TARGET_SAVELIST$ then targetName is the name to save the list to in the SYSLIST table.
UserArg
If Target is TARGET_CALLBACK$ then userArg accepts a string argument which will be passed to the callback function. If RList is called procedurally from another SSP userArg will return with the last value set by the callback function.
If Target is TARGET_SAVELIST$ then userArg accepts a description string to be saved into the header of the saved list.
Debugflag
If set, the RList output program is saved to disk as RLIST_OUT record in SYSOBJ and the query is not executed.
World leaders in all things RevSoft
At 01 AUG 2022 05:54PM Barry Stevens wrote:
What is the LIST option(? that creates the source code for the list statement. Too many years have passed since last did this and cant see in documentation.
Cut and paste from the HELP file on RLIST rouitine. See DEBUG_FLAG
RList routine
Description
The processing module for OpenList queries RList takes the OpenList statement. The Report Designer uses RList to access data for queries.
Syntax
RList(statement, target, targetname, userarg, debugflag)
Parameters
The Rlist routine has the following parameters.
Parameter
Description
Statement
TheOpenList statement to process.
Target
If statement is a List statement, target is TARGET_PRINTER by default.
If statement is a Select statement, target is TARGET_SAVELIST by default.
TargetName
If Target is TARGET_CALLBACK$ then targetName is the name of the callback function. If targetName is null or invalid, a loading error will occur.
If Target is TARGET_SAVELIST$ then targetName is the name to save the list to in the SYSLIST table.
UserArg
If Target is TARGET_CALLBACK$ then userArg accepts a string argument which will be passed to the callback function. If RList is called procedurally from another SSP userArg will return with the last value set by the callback function.
If Target is TARGET_SAVELIST$ then userArg accepts a description string to be saved into the header of the saved list.
Debugflag
If set, the RList output program is saved to disk as RLIST_OUT record in SYSOBJ and the query is not executed.
World leaders in all things RevSoft
Yeah found that and was elated, BUT, the output is not related to the output expected, seemed more like a proforma.
At 03 AUG 2022 04:20AM Andrew McAuley wrote:
My recollection is that it is literally just the code to read the rows and format the list output basically like to a dot matrix. All the rest of the formatting is done internally. 'Twas ever thus. Doesn't even include the select clauses.
World leaders in all things RevSoft
At 04 AUG 2022 01:21AM Barry Stevens wrote:
My recollection is that it is literally just the code to read the rows and format the list output basically like to a dot matrix. All the rest of the formatting is done internally. 'Twas ever thus. Doesn't even include the select clauses.
World leaders in all things RevSoft
Ok, tried again and it produced the expected results. Dont know what I saw before.
Anyway, thanks for the confirmation.
* * output is in sysobj RLIST_OUT * statement ="LIST SYSREPOS APPID JUSTLEN 12 ENTITYID JUSTLEN 30 UPDATED BY TYPEID BY APPID BY ENTITYID WITH UPDATED GE '02 FEB 2022 00:01' AND WITHOUT TYPEID EQ 'approw' 'DBTABLE' 'dbcolumn' 'oiwinexe' 'stprocdbg' 'stprocexe' ID-SUPP BREAK-ON TYPEID" call RList(statement, '', '', '', 1)