ID: 30677 Updated by: [EMAIL PROTECTED] Reported By: ian at rolfe dot com -Status: Analyzed +Status: Assigned Bug Type: Documentation problem Operating System: n/a PHP Version: Irrelevant -Assigned To: +Assigned To: mez New Comment:
from Microsoft SQL_BEST_ROWID: Returns the optimal column or set of columns that, by retrieving values from the column or columns, allows any row in the specified table to be uniquely identified. A column can be either a pseudo-column specifically designed for this purpose (as in Oracle ROWID or Ingres TID) or the column or columns of any unique index for the table. SQL_ROWVER: Returns the column or columns in the specified table, if any, that are automatically updated by the data source when any value in the row is updated by any transaction (as in SQLBase ROWID or Sybase TIMESTAMP). I'll update this in a moment Previous Comments: ------------------------------------------------------------------------ [2004-12-29 22:36:09] [EMAIL PROTECTED] from Microsoft SQL_BEST_ROWID: Returns the optimal column or set of columns that, by retrieving values from the column or columns, allows any row in the specified table to be uniquely identified. A column can be either a pseudo-column specifically designed for this purpose (as in Oracle ROWID or Ingres TID) or the column or columns of any unique index for the table. SQL_ROWVER: Returns the column or columns in the specified table, if any, that are automatically updated by the data source when any value in the row is updated by any transaction (as in SQLBase ROWID or Sybase TIMESTAMP). I'll update this in a moment ------------------------------------------------------------------------ [2004-12-29 22:02:17] ian at rolfe dot com No, read it more carefully: for the type argument SQL_ROWVER the documentation says: "When the type argument is SQL_ROWVER, odbc_specialcolumns() returns the optimal column or set of columns that, by retrieving values from the column or columns, allows any row in the specified table to be uniquely identified. " This is pretty much the same as it says for SQL_BEST_ROWID, but the SQL_ROWVER and SQL_BEST_ROWID are distinctly different operations for this function. The ODBC driver documentation I have (and can be seen at microsoft.com amongst other places) defines the SQL_ROWVER operation as "columns that are automatically updated when any value in the row is updated by a transaction" which is not the same as the "optimal column or set of columns that, by retrieving values from the column or columns, allows any row in the specified table to be uniquely identified"! ------------------------------------------------------------------------ [2004-12-29 18:11:07] [EMAIL PROTECTED] I think the Documentation says the same as you've just written, except for worded differently ------------------------------------------------------------------------ [2004-12-29 18:10:36] [EMAIL PROTECTED] I think the Documentation says the same as you've just written, except for worded differently ------------------------------------------------------------------------ [2004-11-03 18:42:07] ian at rolfe dot com Description: ------------ There are a couple of problems with the documentation for odbc_specialcolumns First, the type parameter: * When the type argument is SQL_BEST_ROWID, odbc_specialcolumns() returns the optimal column or set of columns that, by retrieving values from the column or columns, allows any row in the specified table to be uniquely identified. * When the type argument is SQL_ROWVER, odbc_specialcolumns() returns the columns that are automatically updated when any value in the row is updated by a transaction. The "string qualifier" is the database name ("Catalogue" as referred to in other documentation). ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=30677&edit=1