RLIST (OpenInsight 32-Bit)
At 15 MAR 2005 09:04:41AM Mike Norton wrote:
This is probably a bit of an "old chestnut" but it's driving us up the wall. Need to build a report using BREAK-ON options.
RUN RLIST "LIST PATIENTS WITH ADMITTED_DATE ]= '01/01/05' AND WITH ADMITTED_DATE ⇐ '31/03/05' BY CONSULTANT BREAK-ON CONSULTANT 'V' TOTAL UNIT ID-SUPP DET-SUPP","1"
(UNIT is just a calcuated column (@ANS=1) to aid counting etc.)
Have seen recommendations to use System Monitor and have tried that with no joy, request works with 'V' missing, fails with "SYS1240: A comma or quote is missing in the script." error if use "'V'" (as described in manual) and in the form above have no errors but equally have no output!
At 15 MAR 2005 09:16AM Colin Rule wrote:
May not be the answer, but isn't the V supposed to be in single quotes within double quotes with optional text either side, ie
" blah 'V' blah "
Colin
At 15 MAR 2005 09:24AM support@sprezzatura.com wrote:
You can't issue this from either the system editor or system monitor because both types of quotes are required.
sentence=LIST PATIENTS WITH ADMITTED_DATE ]= "01/01/05" AND WITH ADMITTED_DATE = "01/01/05" AND WITH ADMITTED_DATE The Sprezzatura Group Web Site
World Leaders in all things RevSoft
At 15 MAR 2005 09:38AM Michael Norton wrote:
Thanks guys, I was sort of hoping there was a work around for System Editor so client could have a quick fix today but hey-ho……don't suppose there is any chance Revelation would like to take this on an introduce a third set of "quote delimiters", I seem to remember some old PICK systems used to accept / marks in place of quotes to avoid similar issues.
At 15 MAR 2005 10:20AM Dave Harmacek wrote:
Why don't you make up a form with an EditBox for the statement and a RUN button?
At 15 MAR 2005 10:25AM support@sprezzatura.com wrote:
A third party reporting product allows this, but I don't think we're allowed to self-promote S/List without prior permission.
support@sprezzatura.com
The Sprezzatura Group Web Site
World Leaders in all things RevSoft
At 15 MAR 2005 10:44AM Mike Ruane wrote:
Have you tried this from TCL?
At 15 MAR 2005 11:10AM Mike Norton wrote:
Hi Mike, I've tried it from Exc: line in System Editor and System Monitor, same problem in both environments
At 16 MAR 2005 10:49AM Alun Hutchings wrote:
If you are using system monitor you must enclose the V with one single quote and two sets of double-quotes. You can also use between dates so…
RUN RLIST "LIST PATIENTS WITH ADMITTED_DATE BETWEEN '01/01/05' AND '31/03/05' BY CONSULTANT BREAK-ON CONSULTANT ""'V'"" TOTAL COUNT ID-SUPP DET-SUPP","1"
is what you really need (I think)