Problem : creating UKD via DI-API (SQL Server 2005)

[Former Member]

Hello,

I have a serious problem with

user defined key

, i can't create an user key when it's type is alphanumic via DI-API or in SBO application. An error message is displayed : [SQL Native Client][SQL Server]Column 'U_Col1' in table 'dbo.@Table1' is of type that is invalid for use as key column in an index.'Description clé utilisateur' (OUKD).

Note : I use the SAP Business One SP01 PL18 with SQL Server 2005

Thant you.

[Former Member]

Hi Sofiane,

Maybe if you share your code here we can help you better.

Regards,

Ian

[Former Member]

Hi Ian,

The portion of code is :

dim oKey as B1DbKey = New B1DbKey("Table1", "MyKey", True, New String() {"Col1"})

oKey.Add(B1Connections.diCompany)

I have tested the same code on <b>SAP Business One 2007 A preview version</b> and it work well

Regards

Sofiane

[Former Member]

Hi All

The problem of creating the UDK on a column with a type of alphanumeirc under SQL SERVER 2005 are fixed in patche level 19. You can download it from SAP site.

Regards.

[olivier_huet3]

What's the type of U_Col1 ?

You cannot build an index with a Memo field.

[Former Member]

Hi Olivier,

The type of U_Col1 is alphanumric (length is 10).

Regards