×
Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...
SAVING EVAL in TAFJ
- USZ
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 4
- Thank you received: 1
3 years 1 month ago #23297
by USZ
SAVING EVAL in TAFJ was created by USZ
How to convert this code in TAFJ as EVAL is not supported?
SEL.USER1 = "SELECT F.USER WITH END.DATE.PROFILE GT '" : SEL.DAT : "'"
SEL.USER2 = " SAVING EVAL 'SIGN.ON.NAME:" : DQUOTE('*') : ":COMPANY.CODE<1,1>:": DQUOTE('*') : ":USER.NAME[1,10]' BY SIGN.ON.NAME"
SEL.USER = SEL.USER1:SEL.USER2
SEL.USER1 = "SELECT F.USER WITH END.DATE.PROFILE GT '" : SEL.DAT : "'"
SEL.USER2 = " SAVING EVAL 'SIGN.ON.NAME:" : DQUOTE('*') : ":COMPANY.CODE<1,1>:": DQUOTE('*') : ":USER.NAME[1,10]' BY SIGN.ON.NAME"
SEL.USER = SEL.USER1:SEL.USER2
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
Less
More
- Posts: 1116
- Thank you received: 150
3 years 1 month ago #23318
by VK
Cheers
VK
Replied by VK on topic SAVING EVAL in TAFJ
Hi
1. SELECT without EVAL
2. Read records.
3. Reproduce EVAL results in the code.
FYI - here's what I found in the bowels of Temenos support site:
Maybe you can share here what else doesn't work? Thanks.
1. SELECT without EVAL
2. Read records.
3. Reproduce EVAL results in the code.
FYI - here's what I found in the bowels of Temenos support site:
"not supported in TAFJ"
CATS(), CHAR(), COUNT(), DATE(), DCOUNT(), FIELD(), FIELDS(), ICONV(), LEN(), LOWER(), MATCHES(), MATCHFIELD(), RAISE(), SUBSTRING(), SUM(), FMT(), OCONV()
!HUSHIT
IDESC
ESEARCH, SEARCH, LIST, LIST-ITEM, REFORMAT, SREFORMAT, SDUMP, TLOAD, SORT, SORTITEM, SORTLABEL, STAT, SUM, TDUMP, TLOAD.
EXECUTE "SELECT"
EXECUTE "SELECT DATA MYFILE"
EXECUTE "SELECT DICT MYFILE"
EXECUTE "SELECT ../MYFILE" where MYFILE is a UD file (WE SHOULD NOT BE USING UD FILES!!!)
EXECUTE "SELECT MYFILE WITH etc" where MYFILE is a UD file (WE SHOULD NOT BE USING UD FILES!!!)
Maybe you can share here what else doesn't work? Thanks.
Cheers
VK
Please Log in or Create an account to join the conversation.
- USZ
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 4
- Thank you received: 1
3 years 1 month ago #23323
by USZ
Replied by USZ on topic SAVING EVAL in TAFJ
I heard these won't work either.
OPENSEQ, READSEQ does not support SETTING keyword.
!PRINT ON
DELETE with LOCKED
IF Condition with multiple value for one variable.
Unsupported JQL SELECT query with multiple values.
"@ID"
"++Variable" or "--variable" or "Variable++" or "Variable--"
Comment lines with "//"
"//" operator and the expression cannot be concatenated
"@" with INPUT
SELECTINDEX
INPUTERR statement to print a formatted error message
CHAIN("LO")
CHARX
SELECTV
CALLC
OPEN with ON ERROR
OPENSEQ, READSEQ does not support SETTING keyword.
!PRINT ON
DELETE with LOCKED
IF Condition with multiple value for one variable.
Unsupported JQL SELECT query with multiple values.
"@ID"
"++Variable" or "--variable" or "Variable++" or "Variable--"
Comment lines with "//"
"//" operator and the expression cannot be concatenated
"@" with INPUT
SELECTINDEX
INPUTERR statement to print a formatted error message
CHAIN("LO")
CHARX
SELECTV
CALLC
OPEN with ON ERROR
The following user(s) said Thank You: VK
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
Less
More
- Posts: 1116
- Thank you received: 150
Time to create page: 0.115 seconds