Information

Title	Is the Progress RECID function supported on an SQL-92 query?

URL Name	P83803

Article Number	000157520

Environment	Product: Progress Version: 9.x Product: OpenEdge Version: 10.x, 11.x OS: All supported platforms

Question/Problem Description

Is the Progress RECID function supported on an SQL-92 query?
Can I call the ABL/4GL RECID function from within an OpenEdge SQL WHERE clause?

Steps to Reproduce

Clarifying Information

Error Message

Defect Number

Enhancement Number

Cause

Resolution

The Progress RECID function is not supported with Progress SQL-92.

The ROWID function is the equivalent function in Progress SQL-92.

For example, run this SQL-92 query against the sample sports database:

1. From SQLEXP run the following code:

SELECT ROWID FROM pub.customer;

or

2. From Procedure Editor run the following code:

SELECT string(ROWID(Customer)) FORMAT "X(25)" FROM customer

Please note that from procedure editor there is no semicolon ";" at the end of the select statement.

Workaround

Notes

References to Other Documentation:

Progress article(s):

FAQ: Recid and Rowid
Is there any plan to discontinue RECID over ROWID?

Keyword Phrase

Last Modified Date	11/20/2020 7:14 AM