on 09-29-2008 1:13 PM
Hi All,
I have written the below query in Sp_SBO_SP_TransactionNotification to make one of the tax information field mandatory
IF @transaction_type IN (N'A', N'U') AND (@Object_type = N'2')
BEGIN
declare @n varchar
SELECT @n = T1.TaxId0 FROM ocrd T0 inner join crd7 T1 on
T1.cardcode=T0.cardcode where
T0.cardcode = @list_of_cols_val_tab_del AND
((T1.TaxId0 is not null))
IF (ISNULL(@n, 0) = 0)
BEGIN
SET @error = 10
SET @error_message = N'PlsNo'
end
END
Please help where am i going wrong.
Thanks In Advance
Regards,
Kanishka
Hi Anjan,
Can you let me know what tool your using for mandatory
fields. It sounds like it would be useful.
thanks Carney
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Experts
We have built a tool for mandatory field, there is no SDK used for this.
We are maintaining one table, where the user has to fillup some values to make fields mandatory, like Table Name, Field Name etc..
Then we are passing those as a variables into SBO_SP...
So, there is not need to write each piece of code for each field.
Thanks
Anjan Bhowmick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
use this code
IF @transaction_type = 'A' AND @object_type = '2'
BEGIN
If exists (SELECT T0.cardcode FROM ocrd T0,crd7 t1 where T1.taxid0 is null and T0.cardcode=T1.cardcode and T0.cardcode=@list_of_cols_val_tab_del)
begin
SET @error = 10
SET @error_message = N'Please Enter Tax Id'
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 |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.