Lost Filters (AREV Specific)
At 07 NOV 1997 05:07:24PM Robert Cheatham wrote:
We are using AREV 2.03 and, sporadically, at TCL
when we GETLIST X or SELECT X, the next command
is not performed on the list but on the entire
file. When this happens FILTER does not appear on
the status line. Logging off and logging back on
solves the problem, but I would like a better
solution.
At 08 NOV 1997 04:41AM Andrew P McAuley wrote:
write a program call IF_LIST_ACTIVE as follows
Sent=Trim(@Sentence)
If @List.Active Then
Perform Field(Sent, " ", 2, 999)End
compile and catalog
Then in your batch command
GETLIST X
IF_LIST_ACTIVE_THEN LIST X
World Leaders in all things RevSoft (Except VIP)
At 10 NOV 1997 11:01AM Victor Engel wrote:
Andrew's solution is a good one, but there's no explanation of what is happening. The symptoms you are encountering happen when a select statement retrieves zero rows.
Arev, instead of activating an empty list (this is how it should work, IMO), does not activate a list at all if no rows are selected. There being no active list, your next statement uses the entire file.
At 10 NOV 1997 06:03PM Robert Cheatham wrote:
Actually, there should be an active list. After
the Select statement, the system will say "X
record(s) have been selected," but somehow
it loses this active list. We ran AREV for years
without encountering this problem, but now it
occurs on all workstations with some regularity.
As I said, if you logout of AREV and reload the
program, this problem is solved, but it may occur
again a few hours later.