Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025

 


Article

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

« Go Back

Information

 
Article Number000022085
EnvironmentProduct: 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/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):

000030113, FAQ: Recid and Rowid
000076624, Is there any plan to discontinue RECID over ROWID?
Attachment 
Last Modified Date7/19/2017 12:50 PM