#30677 [Ana]: Documentation of odbc_specialcolumns incorrect

ID:               30677
Updated by:       mez@php.net
Reported By:      ian at rolfe dot com
Status:           Analyzed
Bug Type:         Documentation problem
Operating System: n/a
PHP Version:      Irrelevant
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: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] 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