on 12-27-2016 1:37 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
try to use the field Absentry in OCRB table,
Kind regards
Agustín Marcos Cividanes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
9 | |
8 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.