We are running Information flavor...... Could be.
> -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Richard A. Wilson > Sent: Thursday, July 07, 2011 11:46 AM > To: U2 Users List > Subject: Re: [U2] Found something interesting.....Bug or No Bug....that > is my question? > > Prime information also returned a hit anytime > the following syntax was used > > I'm guessing UV tried to emulate prime whenever possible > > SELECT filename recordid > > perhaps a different flavor would yield different > results > > Rich > > > > Dianne Ackerman wrote: > > 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 > > > > -- > Richard A Wilson > Lakeside Systems > Smithfield, RI, USA > Voice 401-231-3959 > Fax 206-202-2064 > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
