Possible Bug in Rlist? (OpenInsight 32-Bit)
At 21 NOV 2005 03:04:49PM John Bouley wrote:
I am having a problem sorting, reporting and breaking on a multi-valued field. I have tried Slist and Run_Report and get the same results.
Take the following:
clearselect 0
sent=SELECT ORDERS WITH BILLING_STATUS=N' BY PRODUCT_NO BY PROMISE_DATE BY RECEIVE_DATE"
call rlist(sent,5,
,,) sent=SELECT ORDERS WITH STATUS_LI=OPEN' AND WITH PRODUCT_NO NE"call rlist(sent,5,
,,) sent=LIST ORDERS BREAK-ON PRODUCT_NO COLHEAD "Item ID" PROMISE_DATE COLHEAD "Promised" RECEIVE_DATE COLHEAD "Received" CANCEL_DATE COLHEAD "Cancelled" TOTAL QTY COLHEAD "Qty" TOTAL REMAINING_QTY COLHEAD "Remain" ORDER_NO COLHEAD "Order No" ' call run_report(,sent,'SCREEN')However, if I save_select the list and then rerun with Activate_save_select the results are correct. Also, if I omit the second select the results are correct!
So it would appear that second call to Rlist seems to have corrupted the results some how???
Any help would be greatly appreciated.
Thank You
At 21 NOV 2005 04:27PM Warren Auyong wrote:
As I recall there are differences in how NE
works vs ARev 3.12 but my memory is getting bad. What happens if you try "WITHOUT PRODUCT_NO EQ" or "WITH PRODUCT_NO GT ''"?Then again RLIST gives very little feedback on syntax errors or non-existant dictionary times (typos etc) either such as having a space before and after parens around with clauses.
At 21 NOV 2005 04:35PM John Bouley wrote:
My experience is that NE works where Without is suspect but I could be wrong.
At any rate the problem only manifests itsef when I execute the second Rlist that further filters the Exploded sort. On the other hand, if I save the results of the second Rlist and run the report by using an Activate_Save_Select it works…
John