suppressing and continuing from "no records selected" (AREV Specific)
At 15 JAN 2004 04:28:33PM Jim Tassano wrote:
Arev 2.12. When I run a select command and it returns "no records found", how can I stop that and continue on with processing, without having to hit ENTER?
At 15 JAN 2004 05:00PM Victor Engel wrote:
Are you looking for something like this?
At 15 JAN 2004 05:49PM Jim A Tassano wrote:
The command is something like "select customerfile with date eq Date()" If no records are found a message pops up saying "no records found". It then waits for an input. I just want it to continue processing if no records are found, without any interaction from me.
At 16 JAN 2004 04:03AM [email protected] wrote:
If i get what you mean AND any ArevCells left ..
add (S) to your statement. This should suppress the message
Another cute one is (X) This actually generates a program and puts it in your arev directory called RLIST. Everything there but the select. Works great for 'Rlist is almost right but .. '
Phone: 971-570-2005
OS: WinXP Pro
OI: 7.0
At 16 JAN 2004 06:18AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Sig is (of course) correct but bear in mind that your following process should check for an active select list so as not to accidentally process the entire file.
The normal trick for this is to prepare and catalog a command called say CONTINUE_IF_SELECT_ACTIVE that says something like
Sent=Trim(@Sentence)
Rest=Field()@Sentence, " ", 2, 999999)
If @Rec.Count ] 0 Then Perform Rest
and in your batch file have
SELECT WHATEVER
CONTINUE_IF_SELECT_ACTIVE NEXTPROCESSHERE
World Leaders in all things RevSoft
At 16 JAN 2004 09:30AM [email protected] wrote:
hmm glad i was partially right .. but never used 'The normal trick…'
not sure why you need a seperate routine to tell you you didn't get any items but then as I have said before .. i am pretty dense
Phone: 971-570-2005
OS: WinXP Pro
OI: 7.0
At 16 JAN 2004 09:54AM Don Miller - C3 Inc. wrote:
DSig .. Well .. just in case you don't want the whole bloody file listed. I've used the "trick" in AREV/REV for many moons. (IF_ANY_THEN). It sure beats having to write a piece of R/BASIC code to check whether a SELECT returned any data.
Don M.
At 16 JAN 2004 10:10AM The Sprezzatura Group wrote:
SELECT INVOICES WITH AMOUNT ] 10000
LIST INVOICES AMOUNT DATE (P
No invoices ] 10000 - total printout of entire file…
The Sprezzatura Group
World Leaders in all things RevSoft
At 16 JAN 2004 10:44AM Victor Engel wrote:
No, it's not to TELL you there are no items. It is to allow a streamlined flow in a TCL batch in the event there are no records selected.
At 16 JAN 2004 07:42PM Jim A Tassano wrote:
(P sends a select list the printer.
I was hoping there was a nice simple command that would continue the processing of the reports that I have linked together. I do not really care that no records were selected. Seems nuts to just have the whole thing stop and wait for an input from me. Really slows things down.
At 17 JAN 2004 12:16AM Bob Carten wrote:
Jim
I think Sprezz has shown you the way.
You should be able to string as many reports together as you need,
without stopping upon empty selects,
e.g.
! First Report ….
SELECT TABLE1 WHATEVER (S)
CONTINUE_IF_SELECT_ACTIVE LIST TABLE1 … (P
! Second Report ….
SELECT TABLE2 WHATEVER_ELSE (s)
CONTINUE_IF_SELECT_ACTIVE LIST TABLE2 … (P
!(D)
At 17 JAN 2004 12:43PM Richard Hunt wrote:
Jim,
I am not sure about revision 2.1 although in revision 3.0 you can modify the "B285" row (record) in the "SYSMESSAGES" table (file). Change field 1 to something like "T1", display for one second.
At 19 JAN 2004 04:03AM [email protected] wrote:
At TCL sure .. but if you are doing it at tcl there is no reason to do a select now is there.
Phone: 971-570-2005
OS: WinXP Pro
OI: 7.0