Absolutely. SELECT on a SELECT will prune the list if there is an active select and matching criteria. What should NOT happen is zero records on the second SELECT if you know the record is present - irrelevant of syntax
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bill Haskett Sent: 07 July 2011 17:24 To: U2 Users List Subject: Re: [U2] Found something interesting.....Bug or No Bug....that is my question? I'm not sure about that. This, I believe, has always been the case. I've always had problems worrying about whether the 1st select returned anything; that's why I always do a SYSTEM(11) test after the initial select, and rarely use the trick of loading TCL commands into an array to execute all at once (unless I know for sure this condition won't occur). UD v7.2.7 responds as I've always expected: 5 Dev (0)-> BPTEST CMD = \SELECT SOMEFILE WITH INVNO = "1234567"\ ; CMD<-1> = \SELECT SOMEFILE "3 71*1"\ ; EXECUTE CMD ; END Compiling Unibasic: SAVEDLISTS\BpTest_334914081 in mode 'p'. compilation finished No data retrieved from current (S)SELECT statement. 1 records selected to list 0. ...which treats the 2nd execute as its own if the 1st execute returns no data from its select. HTH, Bill ------------------------------------------------------------------------ ----- Original Message ----- *From:* [email protected] *To:* U2 Users List <[email protected]> *Date:* 7/7/2011 9:02 AM *Subject:* Re: [U2] Found something interesting.....Bug or No Bug....that is my question? > 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 Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== tqU8Szsdb6q+D60dYsLMkVk+N89MWS9AodmYIqzE2R4VA== 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
