ID: 25757 Updated by: [EMAIL PROTECTED] 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
