Progress
DataServer for
Microsoft SQL Server
Guide
RECID Function
For backward compatibility, the DataServer supports the RECID function for MSS data source tables that have a unique 4-byte integer column.
When create RECID field is switched on, the Progress-to-MSS migration utility creates an indexed NUMBER column with unique values for each row called PROGRESS_RECID. You can also add this column to tables manually if you are using an existing SQL Server™ database or if you ported a Progress database without the create RECID field switched on.
If the Progress _RECID field does not exist in the table, the DataServer utility automatically designates the index that meets the unique key criteria. 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 |