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

  • Thread starter Thread starter gus bjorklund
  • Start date Start date
Status
Not open for further replies.
G

gus bjorklund

Guest
RECID and ROWID are not the same thing and were never intnded to be so. Since time immemorial, RECID's were stored as 32-bit integers and you could freely convert between the two. When 64-bit integer daattype was introduced to the 4GL, this conversion ability was retained. ROWID's are NOT integers. They are variabkle kenght byte strings. When they were added to the 4GL, they could (and still can) have values much larger than 32-bit integers. Although some ROWID values can be converted to integers, many cannot (and vice versa). This is the reason that there is no easy function to convert ROWID';s to RECID's. This was a deliberate decision, not an accident. Furthermore, there is no need at all for such conversion. Just use ROWID's and dont try to convert them to anything else.

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