, ,

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

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.

View this thread on the Works forum...