ITYPE function fails under certain circumstances

65 views
Skip to first unread message

JOSE L MARTINEZ-AVIAL

unread,
Nov 20, 2019, 4:35:50 PM11/20/19
to jb...@googlegroups.com
Hello all,
  I'm having an issue that is puzzling me, so I want to see if somebody can help.

 We have a table with two fields PRINCIPAL.BLECB and NACE. There is also two IDESC fields that link those fields to two master tables to retrieve the description of those two fields

jsh miasup ~ -->CT ../bnk.dict/F.IDOM.RE000]D PRINC.BLECB.DESC
    PRINC.BLECB.DESC
001 I
002 PRINCIPAL.BLECB; SUBR("ENQ.TRANS","RE.STAT.REP.LINE", @1, "DESC")
003
004 PRINC.BLECB.DESC
005 24L
006 M
007
008
009
010
011
012
013
014 PRINCIPAL.BLECB; SUBR("ENQ.TRANS","RE.STAT.REP.LINE", @1, "DESC")

jsh miasup ~ -->CT ../bnk.dict/F.IDOM.RE000]D NACE.CODE
    NACE.CODE
001 I
002 INDUSTRY; SUBR("ENQ.TRANS","INDUSTRY", @1, "NACE")
003
004 NACE.CODE
005 26L
006 M
007
008
009
010
011
012
013
014 INDUSTRY; SUBR("ENQ.TRANS","INDUSTRY", @1, "NACE")

I've created a program TEST.IDESC (attached) to calculate and retrieve both ITYPE fields. The curious thing is that if I request them in order PRINC.BLECB.DESC, NACE.CODE, it works correctly, but if I do in the reverse order, it fails while retrieving the second one

jsh miasup ~ -->TEST.IDESC
PRINC.BLECB.DESC 22330000000▒DEMAND DEPOSITS.
NACE.CODE NACE06
jsh miasup ~ -->

jsh miasup ~ -->TEST.IDESC
NACE.CODE NACE06
Error in Itype:
Named Attribute PRINCIPAL.BLECB not found.
PRINC.BLECB.DESC
jsh miasup ~ -->

any idea what the problem may be?

thanks

JL


TEST.IDESC

Amila Kaluarachchi

unread,
Nov 21, 2019, 3:07:06 AM11/21/19
to jb...@googlegroups.com
Rebuild the standard selection and try

--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

---
You received this message because you are subscribed to the Google Groups "jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbase+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/CAHB4ARsfhD8dDia89L-LHDk2qP9dSU%3DHm2FCJZSCtFUjV6c9ag%40mail.gmail.com.
Reply all
Reply to author
Forward
0 new messages