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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved.
Last updated: Fri Apr 19 18:01:28 2024 UTC