A pseudo column behaves like a table column, but is not actually stored in the table. You can select from pseudo columns, but you cannot insert, update, or delete their values. This section describes the pseudo columns supported by OpenAccess SDK:
• ROWID: You can identify any column in your tables as a rowid field by marking the PSEUDO_COLUMN attribute as SQL_PC_PSEUDO and the OA_COLUMNTYPE attribute as SQL_BEST_ROWID. Applications use the SQLSpecialColumns ODBC call to identify these columns.
• ROWVER: The row version field is to be updated each time that row is modified. You can identify any column in your tables as a row version field by marking the PSEUDO_COLUMN attribute as SQL_PC_PSEUDO and the OA_COLUMNTYPE attribute as SQL_ROWVER. Applications use the SQLSpecialColumns ODBC call to identify these columns.
Note: In the current release, SQLColumns exposes pseudo columns that result in some applications, such as Microsoft Query, including the pseudo columns in INSERT/UPDATE queries.
