SP_Transaction_Notification Question
hello all,
have a nice day.
i been able to download the manual for SP_TransactionNotification from this URL
im learning how to make SP by myself and some questions bothers my mind.
1. what is the difference of SET & Select?
bcoz i found this line in SP_TransactionNotification manual in page 5. "If you are placing code in the SBO_SP_TransactionNotification, please make sure you always go through the u201Cselect @error, @error_messageu201D line at the end, especially in the case where you want the transaction to be considered as successful."
here is a sample of SP,the first one uses SET and the second uses Select, they both work fine
IF (@object_type = '60') and (@transaction_type IN (N'A', N'U'))
BEGIN
IF EXISTS (SELECT T0.Docentry from OIGE T0 Inner Join IGE1 T1 ON T0.Docentry=T1.Docentry where
T1.DocEntry = @list_of_cols_val_tab_del and (T1.u_DEPT is null or T1.u_based =''))
BEGIN
SET @error = 10
SET @error_message = N'Department Must be filled-up!'
END
END
-
IF (@object_type = '60') and (@transaction_type IN (N'A', N'U'))
BEGIN
IF EXISTS (SELECT T0.Docentry from OIGE T0 Inner Join IGE1 T1 ON T0.Docentry=T1.Docentry where
T1.DocEntry = @list_of_cols_val_tab_del and (T0.U_DEPT is null or T0.U_DEPT =''))
BEGIN
Select @error = 10, @error_message = N'Department Must be filled-up!'
END
END
-
im really confused in this part...
2. when should i use @list_of_key_cols_tab_del or when is @list_of_key_cols_tab_del appropriate to be used.
3. when should i use @list_of_cols_val_tab_del or when is @list_of_cols_val_tab_del appropriate to be used.
Best Regards,
Fidel