×
Discuss on T24 Installation, Setting up the environment, TC Server, jBOSS, Package & Deployment, etc…
Update to T type table
- vijaygubbi
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 23
- Thank you received: 1
12 years 2 months ago #13865
by vijaygubbi
Update to T type table was created by vijaygubbi
Hi All,
Am struggling to update to T type table through Authorization routine.
for updating am using OFS OPM.
"If the record exists then append the record else create new record and update that record".
any one will sort out this query...
Am struggling to update to T type table through Authorization routine.
for updating am using OFS OPM.
"If the record exists then append the record else create new record and update that record".
any one will sort out this query...
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
12 years 2 months ago #13874
by jpb
Replied by jpb on topic Update to T type table
Why do you use OFS, what is is yout T-type table?
A concat ??
Then use
CALL CONCAT.FILE.UPDATE(FN.CONCAT,RECORD.ID,ITEM.ID,'I','AL')
If you use only RECORD.ID (ITEM.ID empty) you get a separate record, if you use ITEM.ID you get multi-line within record. Function I and D is supported, AL means sorting.
A concat ??
Then use
CALL CONCAT.FILE.UPDATE(FN.CONCAT,RECORD.ID,ITEM.ID,'I','AL')
If you use only RECORD.ID (ITEM.ID empty) you get a separate record, if you use ITEM.ID you get multi-line within record. Function I and D is supported, AL means sorting.
Please Log in or Create an account to join the conversation.
- vijaygubbi
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 23
- Thank you received: 1
12 years 2 months ago - 12 years 2 months ago #13876
by vijaygubbi
Replied by vijaygubbi on topic Update to T type table
HI JPB,
Still its not updating in T type table...
this the routine :
INIT:
FN.ACC='F.ACCOUNT' ; F.ACC=''
FN.MULTI='F.RII.MULTI.CCY.ACCT' ; F.MULTI=''
Y.FIELD='LR.LNK.PR' ; Y.POS=''
F.APP='ACCOUNT'
RETURN
OPENFILE:
DEBUG
CALL OPF(FN.ACC,F.ACC)
CALL OPF(FN.MULTI,F.MULTI)
CALL GET.LOC.REF(F.APP,Y.FIELD,Y.POS)
Y.PRM.ACC=Y.POS<1,1>
RETURN
PROCESS:
Y.MULTI.CCY.ID=R.NEW(AC.LOCAL.REF)<1,Y.PRM.ACC>
CALL F.READ(FN.MULTI,Y.MULTI.CCY.ID,R.MULTI,F.MULTI,MULTI.ERR)
RECORD.ID=Y.MULTI.CCY.ID
CALL CONCAT.FILE.UPDATE(FN.MULTI,RECORD.ID,'','I','AL')
RETURN
END
Still its not updating in T type table...
this the routine :
INIT:
FN.ACC='F.ACCOUNT' ; F.ACC=''
FN.MULTI='F.RII.MULTI.CCY.ACCT' ; F.MULTI=''
Y.FIELD='LR.LNK.PR' ; Y.POS=''
F.APP='ACCOUNT'
RETURN
OPENFILE:
DEBUG
CALL OPF(FN.ACC,F.ACC)
CALL OPF(FN.MULTI,F.MULTI)
CALL GET.LOC.REF(F.APP,Y.FIELD,Y.POS)
Y.PRM.ACC=Y.POS<1,1>
RETURN
PROCESS:
Y.MULTI.CCY.ID=R.NEW(AC.LOCAL.REF)<1,Y.PRM.ACC>
CALL F.READ(FN.MULTI,Y.MULTI.CCY.ID,R.MULTI,F.MULTI,MULTI.ERR)
RECORD.ID=Y.MULTI.CCY.ID
CALL CONCAT.FILE.UPDATE(FN.MULTI,RECORD.ID,'','I','AL')
RETURN
END
Last edit: 12 years 2 months ago by vijaygubbi. Reason: commented line
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
12 years 2 months ago #13882
by jpb
Replied by jpb on topic Update to T type table
How are your F.MULTI records designed, what is the key and content . . .
Please Log in or Create an account to join the conversation.
- vijaygubbi
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 23
- Thank you received: 1
12 years 2 months ago #13883
by vijaygubbi
Replied by vijaygubbi on topic Update to T type table
I GOT THE OUTPUT,
THANK YOU
THANK YOU
Please Log in or Create an account to join the conversation.
Time to create page: 0.041 seconds