× 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...

Multivalue Removal via OFS

  • richard
  • richard's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • Posts: 130
  • Karma: 1
  • Thank you received: 1

richard created the topic: Multivalue Removal via OFS

Hi All,

I am trying to remove the multivalue "OTHER.OFFICER" from ACCOUNT application but am not bale to getting erro as below, Can anyone help
jsh R13 ~ -->tSS TAG
<tSS version="1.1"><t24version>R13</t24version><t24pid>1752</t24pid><t24ofssource>TAG</t24ofssource><clientIP/></tSS>
ACCOUNT,/I/PROCESS//0,AUTHOR/123456,64618,OTHER.OFFICER:2=-
64618//-1/NO,OTHER.OFFICER:2:1=MISSING DEPT.ACCT.OFFICER - RECORD
Actual record looks like
ACCOUNT.NUMBER.... 64618               Current Account-SONY-CAD
 ------------------------------------------------------------------------------
   1 CUSTOMER.......... 111661              Sony
   2 CATEGORY.......... 1-001               Current Account
   3 ACCOUNT.TITLE.1... Current Account-SONY-CAD
   5 SHORT.TITLE....... SONYCAD
   6 MNEMONIC.......... SONYCAD
   7 POSITION.TYPE..... TR                  TRADING POSITION
   8 CURRENCY.......... CAD                 Canadian Dollar
   9 CURRENCY.MARKET... 1                   Currency Market
  11 ACCOUNT.OFFICER... 56                  Trade Finance Officer
  12. 1 OTHER.OFFICER.. 1                   Implementation
  12. 2 OTHER.OFFICER.. 2                   Retail Banking Manager-Others
  21 CONDITION.GROUP... 2                   Current Account Others

Best Regards,

Think green – keep this on the screen
#21489

Please Log in or Create an account to join the conversation.

  • Posts: 2839
  • Karma: 512
  • Thank you received: 643

jpb replied the topic: Multivalue Removal via OFS

Try:

ACCOUNT,/I/PROCESS//0,AUTHOR/123456,64618,OTHER.OFFICER:1:2=-

Some people feel the rain - others just get wet (Bob Marley)
#21491

Please Log in or Create an account to join the conversation.

  • richard
  • richard's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • Posts: 130
  • Karma: 1
  • Thank you received: 1

richard replied the topic: Multivalue Removal via OFS

Hi JPB,

Couldn't succeed...
jsh R13 ~ -->tSS TAG
<tSS version="1.1"><t24version>R13</t24version><t24pid>4688</t24pid><t24ofssource>TAG</t24ofssource><clientIP/></tSS>
ACCOUNT,/I/PROCESS//0,AUTHOR/123456,64618,OTHER.OFFICER:1:2=-
[color=red]64618//-1/NO,OTHER.OFFICER:1:1=MISSING DEPT.ACCT.OFFICER - RECORD,OTHER.OFFICER:1:1=MISSING DEPT.ACCT.OFFICER - RECORD,OTHER.OFFICER:1:1=MISSING DEPT.ACCT.OFFICER - RECORD[/color]

Best Regards,

Think green – keep this on the screen
#21492

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 555
  • Karma: 10
  • Thank you received: 80

VK replied the topic: Multivalue Removal via OFS

Hi
then try this (additional colon after "2"):
ACCOUNT,/I/PROCESS//0,AUTHOR/123456,64618,OTHER.OFFICER:2:=-

Also make sure that "-" is ASCII 45 and not some Unicode symbol that might have come from M$ Word or like...

Cheers
VK
#21493

Please Log in or Create an account to join the conversation.

  • Posts: 2839
  • Karma: 512
  • Thank you received: 643

jpb replied the topic: Multivalue Removal via OFS

Normally "ACCOUNT,/I/PROCESS//0,AUTHOR/123456,64618,OTHER.OFFICER:2:=-" should work, try overwriting the current value the same way "ACCOUNT,/I/PROCESS//0,AUTHOR/123456,64618,OTHER.OFFICER:2:=3" ... !

When using "ACCOUNT,/I/PROCESS//0,AUTHOR/123456,64618,OTHER.OFFICER:2:=-" do you get an error, e.g.:

OTHER.OFFICER:2:1=NO DELETION OF LAST MULTI FIELD

or for ACCOUNT,/I/PROCESS//0,AUTHOR/123456,64618,OTHER.OFFICER::=NULL


OTHER.OFFICER:1:1=NO MULTI VALUE FIELD

??

I suspect there is a bug in OFS processing for subvalues . . .at least for ACCOUNT :-(

Some people feel the rain - others just get wet (Bob Marley)
#21494

Please Log in or Create an account to join the conversation.

  • richard
  • richard's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • Posts: 130
  • Karma: 1
  • Thank you received: 1

richard replied the topic: Multivalue Removal via OFS

Hi VK,

This too didn't work got the error as below

jsh R13 ~ -->tSS TAG
<tSS version="1.1"><t24version>R13</t24version><t24pid>10348</t24pid><t24ofssour ce>TAG</t24ofssource><clientIP/></tSS>
ACCOUNT,/I/PROCESS//0,AUTHOR/123456,64618,OTHER.OFFICER:2:=-
64618//-1/NO,OTHER.OFFICER:2:1=MISSING DEPT.ACCT.OFFICER - RECORD

Best Regards,

Think green – keep this on the screen
#21498

Please Log in or Create an account to join the conversation.

  • richard
  • richard's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
  • Posts: 130
  • Karma: 1
  • Thank you received: 1

richard replied the topic: Multivalue Removal via OFS

Hi JPB,

Overwriting is working as expected but the deletion/removal is having problem.

getting same error

<tSS version="1.1"><t24version>R13</t24version><t24pid>10348</t24pid><t24ofssource>TAG</t24ofssource><clientIP/></tSS>
ACCOUNT,/I/PROCESS//0,AUTHOR/123456,64618,OTHER.OFFICER:2:=-
64618//-1/NO,OTHER.OFFICER:2:1=MISSING DEPT.ACCT.OFFICER - RECORD

Best Regards,

Think green – keep this on the screen
#21499

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 555
  • Karma: 10
  • Thank you received: 80

VK replied the topic: Multivalue Removal via OFS

Hi
if it's really a bug you can try to create a VERSION routine that would amend R.NEW matching your requirements... Then trigger that VERSION with OFS (don't specify any field changes in OFS message, just an ID). Should work...

Cheers
VK
#21500

Please Log in or Create an account to join the conversation.

  • Posts: 20
  • Thank you received: 0

woolala replied the topic: Multivalue Removal via OFS

Hi,

Don't use TAG as your ofs source. Try other ofs source such as 'OFS'
jsh R13 ~ -->tSS OFS
<tSS version="1.1"><t24version>R13</t24version><t24pid>4688</t24pid><t24ofssource>OFS</t24ofssource><clientIP/></tSS>
ACCOUNT,/I/PROCESS//0,AUTHOR/123456,64618,OTHER.OFFICER:2:=-
#21517

Please Log in or Create an account to join the conversation.

Time to create page: 0.294 seconds