Re: Firebird return wrong value

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Berko Bubu wrote:
INSERT INTO PRICE (ID, "NAME", COST)


You should not use double quotes around column names. Try to use backtick
operator instead:
INSERT INTO `PRICE` (`ID`, `NAME`, `COST`)
Don't know if that solves the problem, but it's atleast good practice.
Second, do you really need firebird database?
It's pretty outdated database, and there are much better alternatives.
It's an existing system, so i can't change it.
I have tried with firebird 2.5 and same result.

The value stored right. I have seen it in FlameRobin, ISQL, etc
And when i use native native lib (ibase_connect,ibase_prepare,ibase_execute) i get right value.
Maybe is it a bug in pdo_firebird driver ?

This is possible ...
Have you tried the other options to PDO::FETCH_ASSOC ?

I've not bothered with the PDO drivers as the Firebird one can't cope with two-phase commits cross database, and I know that others have found the restrictions imposed by PDO prevent things working well in older style Firebird Applications.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux