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
