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