Sound like a bug to me. UniData is fine. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of George Gallen Sent: 07 July 2011 16:59 To: U2 Users List Subject: Re: [U2] Found something interesting.....Bug or No Bug....that is my question?
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 Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== SZnC6T8Ifm6!Lz2yV!VochA+N89MWS9Aoe8ewgPpp7kgg== to report this email as spam. -------------------------------------------------------- Epicor Software (UK) is a limited company registered in England & Wales. Registration Number: 2338274. Registered Office: Osborne Clarke OWA, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
