Kbase P25924: How to use ROWID with SQL query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/05/2003 |
|
Status: Unverified
GOAL:
How to use ROWID with SQL query
FACT(s) (Environment):
Windows
FACT(s) (Environment):
Progress 9.x
FIX:
ROWID is a Progress extension to the SQL standard. The syntax for the ROWID should be like the following. This is an example that has been tested with 9.1D against a copy of sports:
select * from pub.customer where ROWID < '500'
This returns a result set.
The following is extracted from the documentation:
Returns the row identifier of the current row in a table. This function takes no arguments. The ROWID of a row is determined when the row is inserted into the table. Once assigned, the ROWID remains the same for the row until the row is deleted. At any given time, each row in a table is uniquely identified by its ROWID.
NOTE: Using its ROWID is the most efficient way of selecting the row.
Please refer to the documentation on this.