Progress
DataServer
for ODBC Guide
RECID Function
For backward compatibility, the DataServer supports the RECID function for ODBC data-source tables that have a unique 4-byte integer column.
When compatibility is switched on, the Progress-to-ODBC migration utility creates an indexed NUMBER column with unique values for each row called PROGRESS_RECID. You can also add this column to ODBC tables manually if you are using an existing native data source or if you ported a Progress database without compatibility switched on. For instructions, see "Upgrading DataServer Applications."
The Progress Data Dictionary automatically designates the column that meets the unique 4-byte integer criteria. You can modify an index in an ODBC data-source table to support RECID. For a complete description of the RECID function, see its reference entry in the Progress Language Reference.
You can make an existing application that includes RECID behave more consistently across data sources by replacing RECID with ROWID. See the "ROWID Function" section for more information.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |