Yikes, not what I would have expected. Also happens on 10.2.7
-Dianne
On 7/7/2011 11:02 AM, George Gallen wrote:
UV on Unix - Version 10.0.1
If you do:
SELECT FILENAME WITH FIELD = SOMETHING
And you want to know if ITEM 1234 is in that list
SELECT FILENAME 1234
Will always return a hit (unless it doesn't exist in the FILE) and ignores the
active list
whereas
SELECT FILENAME WITH FIELD = SOMETHING
SELECT FIELNAME WITH @ID = 1234
Will return a zero if it's not in the active list
So....if you don't specify a "WITH" qualifier, it will ignore any active list
and treat it
as if it's a new SELECTion
moral of the story, don't get used to omitting the WITH @ID when doing selects
otherwise, it will bite you if your working with an active list.
George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
[email protected]
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com
_______________________________________________
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
