Bug #3485

metadata method that not work with 'optimize' option of MDB

Details

Submitted	2005-02-15 18:00 UTC
From	fabio at bs2 dot com dot br
Assigned	quipo
Status	Closed
Package	MDB_QueryTool
PHP Version	Irrelevant
Roadmaps	(Not assigned)

Comments

[2005-02-15 18:00 UTC] fabio at bs2 dot com dot br

Description:
------------
When you call "$qt = &new MDB_QueryTool($dsnAlunos ,array('optimize' => 'portability'));" the MDB package work with array index in lower case. But when you call "$qt->add($sameArrayWithIndexInLowerCase)" the method add call metadata method that not work with 'optimize' of MDB and create an error because the method "_checkColumns" return array() and dont insert nothimg

[2005-02-21 18:11 UTC] fabio at bs2 dot com dot br

I'm using Interbase database, and the function ibase_fetch_assoc return an array with index in upper case. In MDB when you set the option 'optimize' to 'portability' the MDB packge return an array with array index in lower case. The packge MDB_QueryTool not use the option optimize, and when you use interbase, metadata method return an array with field names in upper case.