cancel
Showing results for 
Search instead for 
Did you mean: 

UDO problems

Former Member
0 Kudos

Hi, I've just started experimenting with UDO.

I created to tables SM_OTest and SM_OTest1. I added an alphanumeric(20) field to the header table and two alphanumeric(20) fields to the rows. I registered the UDO and allowed the system to create a default form.

When I open the form and try to add, I get the following error:

"Error Converting Data Type nvarchar to int (CINF)"

Why does it do this?

Accepted Solutions (1)

Accepted Solutions (1)

Nussi
Active Contributor
0 Kudos

i had the same problem:

"Error Converting Data Type nvarchar to int (CINF)"

it can happen to upsized compay dbs.

try the following solution:

1) open the stored procedure SBO_SP_TransactionNotification

2) search for the following line:

@object_type int, -- SBO Object Type

3) change the line to:

@object_type nvarchar(20), -- SBO Object Type

now it should work!

Former Member
0 Kudos

Yup that worked! Thanks.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

I would open the form created with the "Screen Painter" and check on the text boxes and/or other controls each Alias and TableName properties to see if one of the controls is pointing to the Code or Name fields of the table for instance.

Or you can find out this by checking the "system information" under view menu and hovering the mouse icon over each control.

hope it helps

Former Member
0 Kudos

I have checked the system information of the table.

in the header:

Code points to Code

and Name points to Name

but when I type anything, even numbers in these fields and try to add I get the error I mentioned before.