[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Getting the string format of ROWID via SQL92

  • Thread starter Thread starter dbeavon
  • Start date Start date
Status
Not open for further replies.
D

dbeavon

Guest
I opened a tech support case so that Progress is at least aware of the case-sensitivity that is enforced by the TO-ROWID function. This is very unexpected behavior and is not logical for anyone that has worked with hex numbers in the past. Most people would assume that, if case sensitivity was "a thing", then it would be the uppercase variety that is the "right" version of a hex. However where ABL ROWID's are concerned, Progress seems to have determined that lowercase is better, for whatever reason. This makes things very confusing when copying the "=DEC2HEX(A1)" output from Excel into ABL.

Continue reading...
 
Status
Not open for further replies.
Back
Top