Returns a designated set of versioned rows. More...
Modules | |
Database Settings | |
Database Interface | |
Database Dialogs | |
SQL Functions | |
Functions | |
Public int | mdlDB_openCursorVersionWithID (CursorID *cursID, WCharCP SQLselectStmt, int versionSet) |
Public long | mdlDB_deletePendingVersion (WCharCP SQLdeleteStmt, int versionId) |
Deletes pending updates from file and restores previous current version values. More... | |
Returns a designated set of versioned rows.
When run against a non-versioned table the only valid mode is MTVS_CURRENT.
[out] | cursID | identical to mdlDB_openCursorWithID |
[in] | SQLselectStmt | identical to mdlDB_openCursorWithID |
[in] | versionSet | MTVS_PENDG, MTVS_PAST, MTVS_CURRENT |
The other select modes simply return rows in the normal manner w/o any implied columns. It is not intended that when a current record set (MTVS_CURRENT) is requested that this call is equivalent to mdlDB_openCursorWithID ; instead, it will return all current state records even though the user may have already made/created his own future state records via previous transactions. This could serve to access a base state or previous value prior to a commit; i.e. - the rows as seen by "others". this call then be followed by the normal mdlDB_fetchRowByID mdlDB_closeCursorByID sequence
Public long mdlDB_deletePendingVersion | ( | WCharCP | SQLdeleteStmt, |
int | versionId | ||
) |
Deletes pending updates from file and restores previous current version values.
[in] | SQLdeleteStmt | valid SQL DELETE statement |
[in] | versionId | version ID of pending row |