cancel
Showing results for 
Search instead for 
Did you mean: 

UDT Table

Former Member
0 Kudos
49

Hi

     I have created UDT table with no object . I want to check if this code exists in other table user should not be able to Update/Delete record.

Please find attached file.

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

edy_simon
Active Contributor
0 Kudos

Hi,

2 ways to do this :

1. Using SP Transaction Notification.

2. Using DI API.

Most reliable way is through SP.

Regards

Edy

Former Member
0 Kudos

Hi Edy

   It is UDT Table with no object . Can we do it through SPN . If not can u help me how to do through DI API

Thanks

edy_simon
Active Contributor
0 Kudos

Hi Sunny,

Using DI, what difficulty did you encounter?

UDT with no object, you handle the update/delete your self in your code.

Just do a query before you update/delete and act based on your query result.

Regards

Edy

Former Member
0 Kudos

hai,

  Crate the class file for NOObject Type then you can control.

 

At Menu Event,

 

For i As Integer = 0 To oMenus.Count

 

If oMenus.Item(i).String.Contains("TableName -")  then

    LoadForm

endif

next

At Form Load,

 

frmFlatPoints = oApplication.Forms.ActiveForm

oDBDSHeader = frmFlatPoints.DataSources.DBDataSources.Item(0)

oMatrix1 = frmFlatPoints.Items.Item("3").Specific.

Regards,

K Sakthivel