#30677 [Ana]: Documentation of odbc_specialcolumns incorrect

ID: 30677 User updated by: ian at rolfe dot com Reported By: ian at rolfe dot com Status: Analyzed Bug Type: Documentation problem Operating System: n/a PHP Version: Irrelevant New Comment: 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"! Previous Comments: ------------------------------------------------------------------------ [2004-12-29 18:11:07] mez@php.net I think the Documentation says the same as you've just written, except for worded differently ------------------------------------------------------------------------ [2004-12-29 18:10:36] mez@php.net 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