a month ago
Can I write a stored procedure that will require the E-Mail field in the contact person tab without? When I enter a contact person, the stored procedure I wrote works, but if nothing is entered in that field and I add a business partner, the stored procedure does not work.
Hi,
Try to replace
INNER JOIN OCPR T1 ON T0.[CardCode] = T1.[CardCode]
by
LEFT JOIN OCPR T1 ON T0.[CardCode] = T1.[CardCode]
Hope this helps,
SonTran
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, this stored procedure
IF @transaction_type IN (N'A','U') AND
(@Object_type = '2')
begin
if exists(select T0."CardCode" from OCRD T0
INNER JOIN OCPR T1 ON T0.[CardCode] = T1.[CardCode]
where
T1.[E_MailL] is null and T0."CardCode" = @List_of_cols_val_tab_del )
begin
SET @error = -77
SET @error_message = 'It is mandatory to enter your e-mail address..'
end
end
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
8 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.