Rlist - Limit not working (OpenInsight 64-bit)
At 19 SEP 2023 11:45:01AM John Bowen wrote:
When running a List statement via Rlist() with a Limit in the statement, the results are not limited to the specified values. This worked in OI 9.4.
I can run the same List statement in Arev64 and only MV rows that have the value are displayed.
Run TestReport, "List Master Description Acct_Code Amount with Acct_Code = '3110' LIMIT Acct_Code = '3110' "
Function testreport(cmd)
Declare Subroutine Rlist
Status =
Results =userarg = "EDT" :@fm: -1 ;* EDT is edit table format, -1 is next available cursor
Rlist(cmd,2,results,userarg)
Return Results
At 19 SEP 2023 12:21PM bob carten wrote:
I see the same behavior.
From TCL or using Run_report, limit is processed correctly.
Using RLIST with target of 2 ( target_variable$ ) LIMIT does not work.
LIMIT is implemented at output, not selection, so your issue suggests a bug in RTI_RLISTX_PRODUCE, which is used by RLIST but not by RUN_REPORT. I'll fix it.