Will et al
As I said, it's only in SQL in UniVerse -
>SELECT COUNT(*) FROM BOOK_TITLES WHERE @ID BETWEEN 1 AND 10;
COUNT ( * )
10
1 records listed.
UniVerse' SQL is bound into the run machine just like RetrieVe (the UV name
for UniQuery, oh I wish there was a standard naming for the mv enquiry
language). You can pretty much mix and match the two: sometimes one is
better for a particular task, sometimes the other.
The main differences being that SQL is more powerful and less friendly, and
you can capture a SQL statement as a result set and iterate through it in
code. You can't do that directly with retrieve, without having to do ugly
things like create compound dictionaries, send it to XML or use Reformat
with @NI as the id.
I've noticed a lot of old-time UV programmers (like me) are resistant to
using SQL, but for fetching data in UV it's very useful and does sometimes
(not always) give the best of both worlds.
Brian
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Wjhonson
Sent: 18 April 2012 20:21
To: [email protected]
Subject: Re: [U2] BETWEEN operator
Curious you're right. I have a Between in my VOC But if I do something like
LIST VOC BETWEEN
or
LIST VOC IF @ID BETWEEN 1 AND 2
or anything like that I just get an error
Unexpected symbol. Token was "BETWEEN"
So I have no idea why it's in the VOC, maybe it's a left over from Prime
days
-----Original Message-----
From: Allen Egerton <[email protected]>
To: U2 Users List <[email protected]>
Sent: Wed, Apr 18, 2012 12:18 pm
Subject: Re: [U2] BETWEEN operator
Universe release 10.3.7 on a Windows platform.
oc entry BETWEEN
1> K
2> 508
No online help for it, and intuitive guess how to use it didn't work, ut
it's definitely there....
n 4/18/2012 3:04 PM, Wjhonson wrote:
The BETWEEN only exists in Unidata's Uniquery Not Universe, as far as I
can see anyway.
Unless they *just* put it into 11.9999 or something
snip>
______________________________________________
2-Users mailing list
[email protected]
ttp://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
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
