What is the Object Type for User Define table ?

[former_member203899]

Dear All Experts,

I create one of the User Define Table with no. of UDF's

I already register User Define Table with Unique ID.

As per my knowledge, Unique ID is our Object type for that User Define Table.

I want to add Transaction Notification Code for created Used Define Table.

This Transaction Notification prevents user to must enter name in that form.

IF (@object_type = 'Z_Roto' AND (@TRANSACTION_TYPE = 'A' or @TRANSACTION_TYPE = 'U'))
BEGIN
If not Exists (Select T0.DocEntry from [@Z_ROTO] T0 Where ( T0.Name is null  OR  T0.Name = ' ' ) AND T0.Code  = @list_of_cols_val_tab_del )
begin


SET @error = 1
SET @error_message = 'Name is NULL then So, Please enter ZERO Value i.e. 0 in Filed_Name'
End
End

Please help me for this problem.

Thanks & Regards,

Nishit Makadia

[former_member203899 · Accepted solution]

Hi All,

Thanks for your replay.

Below code is working for User Define Table's Transaction Notification

IF (@transaction_type = 'A' OR @transaction_type = 'U') AND @object_type = 'Z_Roto'
BEGIN
If Exists (Select T0.Code from [@Z_ROTO] T0 Where ( T0.Name is null  OR  T0.Name = ' ' ) AND T0.Code  = @list_of_cols_val_tab_del)
begin

select @error = 10
select @error_message = 'Name is NULL then So, Please enter ZERO Value i.e. 0 in Filed_Name'
End
End

Necessary to Remember 4 Things. That are mentioned below.

1) Register User Define Table (UDT) with using "Object Registration Wizard". For Example : @object_type = 'Z_Roto'

2) When you define selection criteria then it must be compulsory for use Code Field. For Example : Select T0.Code from [@Z_Roto]

3) When you define selection criteria then it must be compulsory for use Code for @list_of_cols_val_tab_del.

4) Use error code as 10 Number

Thanks & Regards,

Nishit Makadia

[former_member205766]

Hi

Check the below thread

With Regards

Balaji

[former_member203899]

hI,

Thanks for your replay.

I already try this but not work for me.

Thanks & Regards,

Nishit Makadia