D
dbeavon
Guest
When I query the SQL92 engine, it returns integer values for ROWID: SELECT my_table.ROWID from my_table How should that be converted to the "special" string representation of a ROWID? (I believe the format should be "0x0000000013dc65e2"). Better yet, how does it get converted directly to a ROWID from an integer type? Is there any formalized documentation about the "special" string representation of a ROWID ? If I can get it to the "special" string representation, then I know I can get it back to a ROWID using TO-ROWID (see OpenEdge 11.7 Documentation ) I'm doing some trial-and-error and I haven't exactly determine what the "special" string representation of a ROWID should be. For example, TO-ROWID won't work if my rowid is "0x13DC65E2" but *WILL* work if it is "0x0000000013dc65e2". I suspect that things work if we use a lower-case hex string. But that directly contradicts the documentation (see link above). I also attempted to get the "special" string representation of a ROWID directly from my SQL92 query: SELECT TO_CHAR(my_table.ROWID) from my_table ... but this always returns null rather than the "special" hex string. It would be nice if this didn't involve guess-work.
Continue reading...
Continue reading...