Skip to Content
0

Multiple primary key - OCRB

Dec 27, 2016 at 01:37 PM

70

avatar image

Hello,

need your help please,

trying to add code to

SBO_SP_PostTransactionNotice

for table OCRB:

IF @object_type ='187' and @transaction_type IN('A','U')

the problem is that

@list_of_cols_val_tab_del is equal to 4 primary keys, how do i know how to

concatenation the 4 keys togather with spaces between?

select *

from ocrb

where

CardCode +

BankCode+

Country +

Account

=

@list_of_cols_val_tab_del

thank you

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Agustin Marcos Cividanes Dec 27, 2016 at 04:54 PM
0

Hi

try to use the field Absentry in OCRB table,

Kind regards

Agustín Marcos Cividanes

Share
10 |10000 characters needed characters left characters exceeded
Edy Simon Dec 28, 2016 at 01:39 AM
0

Hi Assaf,

As the name of the parameter implies, the values are all tab delimited.
You can check by concatenating the values with (tab) character.

And also, the fields are in the order of Country, BankCode, Account, CardCode

Regards
Edy

Share
10 |10000 characters needed characters left characters exceeded