Selecting Multivalues

#71

Chandru:

Just as a note, I now see why my test worked when it shouldn't have (I was
just lucky). I was only able understand how this worked when I changed the
data like below:

APOPEN...... ACCT. ACCT/AMTS....

830*33312 4500 6017
3070 4495

Then it shouldn't work when I:

Quote:

SELECT APOPEN '830*33312' BY-EXP ACCTS1 < AMTS1

2 record(s) selected to SELECT list #0.

Now I can get rid of the duplicate IDs...

Quote:

SELECT APOPEN SAVING UNIQUE @ID

1 record(s) selected to SELECT list #0.

Now I can test if the association select works...

Quote:

SELECT APOPEN BY-EXP ACCTS1 > AMTS1

0 record(s) selected to SELECT list #0.

Thanks for the clarification. :-)

Bill

P.S. I don't think this works in UniData though, only UniVerse.

"Bill H" <you (AT) notreally (DOT) com> wrote

Quote:

Chandru:

I couldn't get my UV v10.1 to act the way you described. For instance:

LIST APOPEN "830*33312""830*33313""830*33310" ACCTS1 AMTS1 09:48:31am 12
Jul 2006 PAGE 1
APOPEN...... ACCT. ACCT/AMTS....

830*33312 4500 6017
3070 4495
830*33313 3060 6922
3070 5150
830*33310 3060 2071
3070 4172

3 records listed.

4272 Dtademo (0)-> SELECT APOPEN '830*33312''830*33313''830*33310' WITH
ACCTS1 > AMTS1

1 record(s) selected to SELECT list #0.
4272 Dtademo (0)>>CLEARSELECT

Both dictionaries are right justified with no conversions. In fact, here
are the dictionaries:

4272 Dtademo (0)-> AE DICT APOPEN ACCTS1 AMTS1
1 > Top of "ACCTS1" in "DICT APOPEN", 7 lines, 80 characters.
*--: P
001: D
002: 9
003:
004: ACCT
005: 5R
006: M
007:
Bottom.
*--: EX
Quit "ACCTS1" in file "DICT APOPEN" unchanged.
2 > Top of "AMTS1" in "DICT APOPEN", 7 lines, 109 characters.
*--: P
001: D
002: 10
003:
004: ACCT/AMTS
005: 13R
006: M
007:
Bottom.
*--: EX
Quit "AMTS1" in file "DICT APOPEN" unchanged.

I could be missing something here, so forgive my ignorance.

Bill

"murthi" <c_xyz_murthi (AT) seeing_xyz_green (DOT) net> wrote in message
news:VxVsg.3209$hb3.2856 (AT) trndny04 (DOT) ..
No, Anthony's right:

4
0001 10000ý30000 [S]
0002 9999ý29999 [b]

LIST MONEY "4" WITH S < B S B 05:11:22pm 11 Jul 2006 PAGE 1
MONEY......................... S......... B.........

4 10000 9999
30000 29999

1 records listed.

'4' should not have been selected because 10000 is NOT < 9999 & 30000 is
NOT < 29999.

Apparently since 10000 < 29999, the item gets selected. This is obviously
a bug in implementation, as no-one could possibly want that result.

Chandru

"Bill H" <you (AT) notreally (DOT) com> wrote in message
news:gqWdndoMHcrsgSnZnZ2dnUVZ_oqdnZ2d (AT) comcast (DOT) com...
Anthony:

I'm not sure what you mean. When I try this on UV, in Pick mode, I get
the record key where the any salary value is less than the associated
bonus value. The association is taken into account and only the
appropriate record keys are selected.

3196 Dtademo (0)-> .x3,2
SELECT EETOTALS WITH SALARY< BONUS

194 record(s) selected to SELECT list #0.
LIST EETOTALS SALARY BONUS

LIST EETOTALS SALARY BONUS 02:26:03pm 11 Jul 2006 PAGE 1
EETOTALS...... SALARY. BONUS....

1675*9635 30300 59900
830*33309 30600 69830
30700 55860
830*33310 30600 20710
30700 41720
.
.
Press any key to continue...
Quit
3196 Dtademo (0)-

This looks like what you were asking for. The select would return three
(3) keys to process. I think the "BY-EXP" syntax creates multiple
instances of the record keys for those records where more than one
salary value is less than the associated bonus value.

Bill

"Anthony Lauder" <anthony.lauder (AT) gmail (DOT) com> wrote in message
news:1152516236.328198.309050 (AT) s13g2000cwa (DOT) googlegroups.com...

SELECT SALARYFILE WITH SALARY < BONUS

This works fine on UV PE v10.1.

Hi Bill,

Thanks for the idea, and I wish it did work that way, but unfortunately
it does not. The main problem here is that it does not respect the
association - wherein only salary and bonus values in the same physical
position are considered pairs.

Anthony

#72

Glen:

I don't believe this kind of syntax has ever worked on R83, AdvPick, or D3.
:-(

Bill

"Glen B" <no$pamwebmaster@no$pamforallspec.com> wrote

Quote:

"Bill H" <you (AT) notreally (DOT) com> wrote in message
news:Cv-dnaMXvcpAtinZnZ2dnUVZ_qKdnZ2d (AT) comcast (DOT) com...

This, I think, is easily doable in U2, and I think your syntax is
correct.

Unforunately, I have never been able to get it to work on our D3 box:

:LIST INVENTORY WITH DEMAND GT ON.HAND
[4] syntax error

(ONHAND is an invalid dictionary item)
:LIST INVENTORY WITH DEMAND GT ONHAND
[401] no items present.

Bill

I'm sure that glaring bug was fixed in a recent D3 release that would
require me to move to Fedora.
Don't go there Tony! :P

Glen

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Selecting Multivalues

comp.databases.pick comp.databases.pick

Re: Selecting Multivalues - 07-12-2006 , 01:53 PM

Re: Selecting Multivalues - 07-12-2006 , 02:11 PM