[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
apologies. i did not understand that ABL and SQL were being used together on the same data. the SQL syntax needs some improvement to better support rowid and also to include all the same inbuilt functions that are in the 4GL. you might want to make a stored procedure to do the to/from hex representation for SQL. note that rowid to integer conversion might not work right for rows in partitioned tables. it (integer conversion) wont work for 4GL that uses the oracle dataserver either as oracle rowids are longer than 8 bytes.

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