php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #26348 odbc_statistics()
Submitted: 2003-11-21 07:19 UTC Modified: 2003-12-01 04:01 UTC
From: frosty dot z at freesbee dot fr Assigned:
Status: Not a bug Package: ODBC related
PHP Version: 4.3.4 OS: Win 2000
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: frosty dot z at freesbee dot fr
New email:
PHP Version: OS:

 

 [2003-11-21 07:19 UTC] 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...

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-12-01 02:24 UTC] sniper@php.net
Not PHP bug.

 [2003-12-01 04:01 UTC] frosty dot z at freesbee dot fr
Ok, sorry.
Thank you for your answer.
Then the problem should come from Filemaker ODBC's driver.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Thu Jul 03 10:01:33 2025 UTC