#25757 [Opn->Fbk]: odbc_primarykeys error

From: Date: Fri, 31 Oct 2003 14:51:23 +0000
Subject: #25757 [Opn->Fbk]: odbc_primarykeys error
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-49771@lists.php.net to get a copy of this message 
 ID:               25757
 Updated by:       kalowsky@php.net
 Reported By:      dlaroche at nobug dot lu
-Status:           Open
+Status:           Feedback
 Bug Type:         ODBC related
 Operating System: Windows XP Professional
 PHP Version:      4.3.3
 New Comment:

Try using a NULL value instead of "" for the empty 
slots.  That should solve the problem you're seeing.  


Previous Comments:
------------------------------------------------------------------------

[2003-10-05 17:12:12] dlaroche at nobug dot lu

Description:
------------
I'm trying to write a script to convert tables from a Microsoft Access
(version from 97 to 2002) to MySQL. The first step is that I just want
the structure of the tables, so I need several functions from odbc.

But for the primary keys, the function odbc_primarykeys doesn't work.

I read that I can get the key information of a table using the
odbc_statistics function but this function doesn't work aswell.

Reproduce code:
---------------
$resAccessPrimaryKeyList = odbc_primarykeys($resAccessConnection, "",
"", "tblManif");
echo(odbc_result_all($resAccessPrimaryKeyList));

Expected result:
----------------
don't know the result but I want to get a list with the primary keys of
the table.

Actual result:
--------------
Warning:  odbc_primarykeys(): SQL error: , SQL state 00000 in
SQLPrimaryKeys in E:\htdocs\ltam\odbc.php on line 65

Warning:  odbc_result_all(): supplied argument is not a valid ODBC
result resource in E:\htdocs\ltam\odbc.php on line 66


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=25757&edit=1

Thread (6 messages)

« previous php.bugs (#49771) next »