Rex:
This doesn't work on UD v7.1.9 in ECLTYPE "P" with numerous UDT.OPTIONS set for
Pick
mode.
2 Intel (0)-> list APOPEN WHEN (ACCTS UNLIKE "52..." AND ACCTS UNLIKE "29...")
INVDATE COMMENT ACCTS AMTS
APOPEN.... INV-DATE DESCRIPTION........................ ACCT. ACCT/AMTS....
58*6-4 06-01-08 LOAN #123456, 06/2008 5230 246.04
2910 1,025.50
2365 61.08
2980 273.70
5230 50.00
The item looks like:
2 Intel (0)-> AE APOPEN "58*6-4"
Top of "58*6-4" in "APOPEN", 17 lines, 144 characters.
*--: P
001: 9505
002: 14757
003: 14763
004: 43*100
005: LOAN #1472185342, 06/2008
006: 165632
007: 0
008: 165632
009: 5230^2910^2365^2980^5230
010: 24604^102550^6108^27370^5000
011: 200806
012: 200805
013:
014:
015: AUTO
016:
017: 43
Bottom.
*--:
But I've noticed UD has some weird results with the query language. For
instance, we
have a BASIC program that creates a query and outputs to the spooler.
Yesterday the
output for a single column was different based on running the program from
telnet or
from UniObjects (DesignBais). Same report, same BASIC program, same account,
same
dictionaries, same data; but the output of a single column was different.
>From Telnet...
3 Intel (0)-> SORT APOPEN BY ISPD LPTR INVDATE COMMENT FMT "25L" ACCTS BREAK-ON
ISPD
"'V'" TOTAL AMTS CHECKNO
APOPEN.... INV-DATE DESCRIPTION.............. ACCT. ACCT/AMTS.... CK#....
1025*672 01-19-08 PMT ON ACCT#XXX8218 2920 101.19
.
.
980*1033 05-15-08 EMPLOYER MCARE W/H 5020 3.63
-------------
NonPaid 5,594.14
Same query from UniObjects (DesignBais)...
APOPEN.... INV-DATE DESCRIPTION.............. ACCT. ACCT/AMTS.... CK#....
1025*672 01-19-08 PMT ON ACCT#XXX8218 2920 101.19
.
.
980*1033 05-15-08 EMPLOYER MCARE W/H 5020 3.63
-------------
N 5,594.14
The dictionary used by the BREAK-ON looks like...
2 Intel (0)-> AE DICT APOPEN ISPD
Top of "ISPD" in "DICT APOPEN", 9 lines, 212 characters.
*--: p
001: I Output 'NonPaid' if invoice not paid and 'Paid' if it is. Used for break
lines
out output.
002: IF CHECK_ID = "" THEN "NonPaid" ELSE "Paid"
003:
004: \
005: 0R
006: S
007:
008: ISPD2CHECK_ID 42IF CHECK_ID = "" THEN "NonPaid" ELSE "Paid"
009: APOPEN
Bottom.
Although I'm not having problems with the 1st issue (I was merely trying to
recreate
what the OP presented), this second issue does present some problems.
Bill
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:owner-u2-
>[EMAIL PROTECTED] On Behalf Of Rex Gozar
>Sent: Wednesday, June 25, 2008 7:30 AM
>To: [email protected]
>Subject: Re: [U2] Friday query logic
>
>Jeffrey,
>
>I got this to work:
>
>LIST MYFILE WHEN (ACCTS UNLIKE "52..." AND ACCTS UNLIKE "29...") ACCTS AMTS
>
>
>* Universe 10.1.18
>* PICK flavored account
>* "D" dictionary items with mv association
>
>rex
>-------
>u2-users mailing list
>[email protected]
>To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
