#26348 [Bgs]: odbc_statistics()
| From: | frosty dot z at freesbee dot fr | Date: | Mon, 01 Dec 2003 09:01:18 +0000 |
| Subject: | #26348 [Bgs]: odbc_statistics() | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-51453@lists.php.net to get a copy of this message | ||
ID: 26348
User updated by: frosty dot z at freesbee dot fr
Reported By: frosty dot z at freesbee dot fr
Status: Bogus
Bug Type: ODBC related
Operating System: Win 2000
PHP Version: 4.3.4
New Comment:
Ok, sorry.
Thank you for your answer.
Then the problem should come from Filemaker ODBC's driver.
Previous Comments:
------------------------------------------------------------------------
[2003-12-01 02:24:45] sniper@php.net
Not PHP bug.
------------------------------------------------------------------------
[2003-11-21 07:19:46] frosty dot z at freesbee dot fr
Description:
------------
Good morning,
I've tried to use the function odbc_statistics() to get information
from tables of a Filemaker Pro database (using ODBC driver).
With any value I've tried, odbc_statistics() returns always FALSE (+
SQL Error).
Thank you very much for any help or explanation ; I suppose this to be
a bug, but it might be a problem from the Filemaker ODBC driver as
well.
... And sorry for the english mistakes (I'm french)
==========
Similar bugs : bug #25757, bug #18941
Reproduce code:
---------------
$id_odbc = odbc_connect(FM_HOST, FM_LOGIN, FM_PASSWORD);
$res = odbc_statistics($id_odbc, NULL, NULL, "product_family", 0, 0);
// I've tried "" and "%" instead of NULL for the 2nd and 3rd arguments
// I've tried many numbers for the last two (too few doc, I don't know
what they do)
$row = odbc_fetch_array($res);
//print $row['CARDINALITY'];
//etc.
Expected result:
----------------
I expected to be able to get some statistics of a table.
Actual result:
--------------
Here is the actual result :
Warning: odbc_statistics(): SQL error: , SQL state 00000 in
SQLStatistics in c:\maxime\prmt\appli\add_product.php on line 47
Warning: odbc_fetch_array(): supplied argument is not a valid ODBC
result resource in c:\maxime\prmt\appli\add_product.php on line 51
----------------
Curiously, SQL state 00000 means "success", and a SQL error is
generated. Since similar problems have been reported for other
functions such as odbc_columns, I guess this could be a PHP bug...
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=26348&edit=1