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

  • Thread starter Thread starter Rob Fitzpatrick
  • Start date Start date
Status
Not open for further replies.
R

Rob Fitzpatrick

Guest
Hi David, It looks like this IntToHex function is from the days of 32-bit rowids (pre-10.1B). If you change the line in IntToHex to "j = 16 - LENGTH(c)." then you'll get the 64-bit value "0x0000000000A002E1" when your recid is 10486497. As to why you need to add the LC function, to get a find by rowid to work, I'd call that a bug in TO-ROWID. Hexadecimal digits don't have a case, so TO-ROWID should give the same output whether the input string is "0x0000000000a002e1" or "0x0000000000A002E1".

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