If someone who has rights to be able to change them needs to add
"link1" (example-but it can be used) into field 7 of the following DICT
ITEMS
PACKET STATUS TRACKING.ID and PMT.DATE
That will link these fields together so next time you can do:
SELECT CREDITCARD.FILE WITH PMT.DATE = "11/19/2013"
LIST CREDITCARD.FILE WHEN PMT.DATE = "11/19/2013" PACKET STATUS TRACKING.ID
PMT.DATE
George
-----Original Message-----
From: Hilk, Brandon
Sent: Tuesday, November 19, 2013 1:31 PM
To: U2 Users List
Subject: Re: [U2] Simple question - selecting and listing records
You may be right :)
I do no programming with this system, I'm just an end user that's trying
to understand better.
Field......... Type & Field........ Conversion.. Column......... Output
Depth &
Name.......... Field. Definition... Code........ Heading........ Format
Assoc..
Number
@ID D 0 CREDITCARD.FILE 10L
S
PACKET D 2 PACKET 8R
M
STATUS D 10 STATUS 15L
M
TRACKING.ID D 9 TRACKING ID 20L
M
PMT.DATE D 7 D4/ PMT DATE 10R
M
As far as WHEN clause, I tried:
list creditcard.file packet status tracking.id pmt.date when pmt.date eq
"11/19/2013"
and it sorts those dates to be the first results, but it still lists all
the other card entries on that packet before moving to the next record.
Is this just a consequence of how the creditcard.file is set up?
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Wjhonson
Sent: Tuesday, November 19, 2013 12:06 PM
To: [email protected]
Subject: Re: [U2] Simple question - selecting and listing records
Could you post the exact statement you're using with the WHEN clause, a
and also the contents of the DICT items?
I suspect one or more of them is not actually setup as a multivalued
field
-----Original Message-----
From: Hilk, Brandon <[email protected]>
To: U2 Users List <[email protected]>
Sent: Tue, Nov 19, 2013 8:29 am
Subject: [U2] Simple question - selecting and listing records
Hello, I have a quick question regarding listing multivalued fields. I
hope the formatting is retained on this email so my example doesn't get
confusing.
This file is structured for multiple credit card entries under one @id.
How can I alter my LIST command to only show the entries for the date
specified? I tried using "when" in both the LIST and SELECT statements
but didn't get the results I was looking for. I feel like I'm missing
something really basic. Thanks in advance.
}SELECT CREDITCARD.FILE WITH PMT.DATE EQ "11/19/2013"
303 record(s) selected to SELECT list #0.
}}LIST CREDITCARD.FILE PACKET STATUS TRACKING.ID PMT.DATE
CREDITCARD.FILE PACKET.. STATUS......... TRACKING ID......... PMT DATE..
52152162 52152162 APPROVED 25D6TGCD 11/19/2013
52152162 12/31/2013
52152162 01/31/2014
52152162 02/28/2014
52152162 03/31/2014
52152162 04/30/2014
52152162 05/30/2014
52152162 06/30/2014
52152162 07/31/2014
52152162 08/29/2014
52152162 09/30/2014
52152162 10/31/2014
56436495 56436495 APPROVED 259l17j2 02/18/2013
56436495 APPROVED 25a0hfg7 03/18/2013
56436495 APPROVED 25adf4bt 04/18/2013
56436495 APPROVED 25ar1ofv 05/20/2013
56436495 APPROVED 25b7a92o 06/18/2013
56436495 APPROVED 25bk0tpv 07/18/2013
56436495 APPROVED 25c11rl1 08/19/2013
_______________________________________________
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
_______________________________________________
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
