[Progress Communities] [Progress OpenEdge ABL] Forum Post: Convert SQL RowId to OpenEdge ROWID

  • Thread starter Thread starter Peter Strachan
  • Start date Start date
Status
Not open for further replies.
P

Peter Strachan

Guest
We have hit an issue recently where a SQL extract of data via ODBC connection fell over pointing to a specific RowId. To aid in investigating this I would like to convert the SQL RowId integer to an OpenEdge ROWID. I have found some examples of poeple converting the integer to a hex character, then to ROWID via the TO-ROWID function. I have used Progress KB - 4GL. How to convert a ROWID to a RECID and Vice Versa as an example to base my code however when using the ROWID "0x0000000000000881", this seems to burst some form of limit: DEFINE VARIABLE iRowId AS int64 NO-UNDO. /*iRowId = EXP(16, (LENGTH("0x0000000000000881") - 2)).*/ MESSAGE (KEYCODE(SUBSTRING("0x0000000000000881", 2, 1)) - KEYCODE("A") + 10) * EXP(16, (LENGTH("0x0000000000000881") - 2)) skip irowid VIEW-AS ALERT-BOX. Uncommenting the assignment makes the code bomb, any help would be greatly appriciated. Could anyone provide comment on the above or a solution that might help please?

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