on 02-10-2009 10:16 PM
I am trying to catch an "Issue for Production" event in SBO_SP_TransactionNotification. The variables come through as follows:
@object_type nvarchar = 58
@transaction_type nchar = A
@num_of_cols_in_key = 2
@list_of_key_cols_tab_del nvarchar = TransNum Instance
@list_of_cols_val_tab_del nvarchar = 11399 0
Where, in which table, can I find the TransNum 11399? My goal is to relate this to the "Issue for Production" number. Any ideas?
Thanks,
Rob
Any Idesa??
Edited by: Rob Burke on Feb 13, 2009 1:34 AM
what you actually want to do...
Issue for Production object type is 60...
explain in detail regarding what you want to do using SBO_SP_TransactionNotification
Regards,
Neetu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Neetu.
I put the following code in SBO_SP_TransactionNotification
set @error = 1
set @error_message = @object_type + ': ' + @transaction_type + ': ' + CAST(@num_of_cols_in_key as VARCHAR(5)) + ': ' + @list_of_key_cols_tab_del + ': ' + @list_of_cols_val_tab_del
The result when I entered an Issue for Production event was an object_type 58 with other data I could not understand. I also see the 60 object type come through after. I will use the type 60.
We use SQL BIDs for printing based on events in B1 by passing data out from SBO_SP_PostTransactionNotice, that is why I'm looking for the event. Problem solved, thank you,
Rob
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
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.