Progress
DataServer for
Microsoft SQL Server
Guide
Modifying Tables to Support the ROWID Function
If you want to use the ROWID function with a data source, you must make certain changes to your data source table. The following example procedure illustrates how to do this.
To use the ROWID function with a SQL Server™ database, make the following changes to your data source table:
- Add a column of the integer data type named PROGRESS_RECID. The new column must be able to contain null:
- Add a column with identity characteristics named PROGRESS_RECID_IDENT_. The new column must have the numeric data type:
- Create a trigger to maintain the PROGRESS_RECID column:
- Change the nonunique indexes so that they include a PROGRESS_RECID column as the last component:
- If you have already created your schema holder, delete and recreate it.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |