Progress
DataServer
for ODBC Guide


ROWID Function

The ROWID data type provides a unique record identifier that is compatible across Progress databases and ODBC data sources. Applications that use the ROWID function behave in the same way whether they access records in a Progress databases or in an ODBC data source. The ROWID function is more consistent than RECID across data sources. Progress Software Corporation recommends that you replace the RECID function with ROWID in existing applications.

The DataServer supports the ROWID function for ODBC data-source tables that have a unique index. The Progress Data Dictionary uses an index that meets this criterion to provide values for the ROWID function. If you build your schema holder using Progress compatibility from the Progress-to-ODBC utility, the Progress Data Dictionary automatically designates a ROWID index; however, you can select a different unique index in a data-source table to support ROWID. See the "Defining the ROWID" section in "The DataServer Tutorial," for instructions.

The ROWID value in an ODBC data source differs from the ROWID value in a Progress database in the following ways:

Follow these guidelines when using ROWID in applications that you want to deploy across multiple Progress databases and/or ODBC data sources:

For a complete description of the ROWID function, see its reference entry in the Progress Language Reference.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095