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

  • Thread starter Thread starter Stefan Drissen
  • Start date Start date
Status
Not open for further replies.
S

Stefan Drissen

Guest
[quote user="gus bjorklund"]Furthermore, there is no need at all for such conversion. Just use ROWID's and dont try to convert them to anything else.[/quote] If I am reading OPs question correctly, he is trying to extract data via the SQL92 to make use of the sql engines query optimizer capabilities and then import this into ABL where the rest of the rows may be needed. Since the SQL92 engine is exposing rowid as a 19 character leading zero bigint in base 10, it needs to be converted to be usable in ABL, you cannot just use it.

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