Consultor Eletrônico



Kbase P89071: Using RowID as index in ProDataSet equal constraint error in .Net
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   31/08/2004
Status: Unverified

FACT(s) (Environment):

OpenEdge 10.x

SYMPTOM(s):

Added a ROWID field as the primary unique index for a dynamic temp-table in a ProDataSet

The FILL() method works properly

A constraint violation is generated on the .Net side referring to the ROWID field in the temp-table as being data type System.Byte.ByteArray

Calling the 4GL program on the AppServer from a 4GL client works fine

CAUSE:

The ROWID data type is mapped to System.Byte.ByteArray in .Net and it is not possible to use ByteArray in an index in .Net

FIX:

Convert the ROWID to a character string using a callback within the 4GL program