Kbase P168751: TO-ROWID fails with rowid value returned from a .NET Grid
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/25/2010 |
|
Status: Unverified
SYMPTOM(s):
TO-ROWID fails with rowid value returned from a .NET Grid
TO-ROWID fails with rowid value returned from a .NET Grid, returning '?'
TO-ROWID(ultraGrid1:ActiveRow:cells:item["tt-rowid"]:text) returns unknown (?)
LENGTH(ultraGrid1:ActiveRow:cells:item["tt-rowid"]:text) returns 19
LENGTH(STRING(ROWID(salesrep))) returns 18
FACT(s) (Environment):
Field is defined in Temp-table as type ROWID
Field is defined in ProDataSet associated with Temp-table as type ROWID
Column in Grid has type System.String
Affects Infragistics UltraGrid
Affects Microsoft DataGridView
OpenEdge 10.2x
Windows
CAUSE:
Bug# OE00198613
FIX:
Option #1
Trim length of value from Grid to 18 characters. For example:
TO-ROWID(SUBSTRING(ultraGrid1:ActiveRow:cells:item["tt-rowid"]:text,1,18)).
Option #2
Define the field containing the ROWID values as CHARACTER; convert ROWID value to type CHARACTER with the STRING() function when adding them to the temp-table.