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 firebi
Matijn Woudt wrote:
Dear List!
>
>i have a strange problem.
>
>I have a Firebird database (dialect 3). Firebird server: 2.0.6
>I create a table, and insert a row like that:
>CREATE TABLE PRICE (
> ID INTEGER NOT NULL,
> "NAME" VARCHAR(10),
> COST NUMERIC(15, 2));
>
>INSERT INTO PRICE (ID, "
> > 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
On Fri, Jan 18, 2013 at 12:49 PM, wrote:
> Dear List!
>
> i have a strange problem.
>
> I have a Firebird database (dialect 3). Firebird server: 2.0.6
> I create a table, and insert a row like that:
> CREATE TABLE PRICE (
> ID INTEGER NOT NULL,
> "NAME" VARCHAR(10),
> COST NUMERIC(15, 2));
vbe...@mail.com wrote:
result:
Array ( [0] => Array ( [COST] => -0.00 ) )
As a starting point ... can you look at the database using Flamerobin and check
what it shows has been stored. I don't see anything wrong with what you have
done except that 'cost' should perhaps be -1.0, so once we kno
Jochem Maas wrote:
hi Guys,
hope somebody can give me a clue :-),
well about 5 mins after I posted I managed to find a solution thanks to
a man named Ivan Prenosil (who by all accounts knows where his firebird towel
is ;-)
http://www.volny.cz/iprenosil/interbase/ip_ib_code_string.htm
(the sto
I don't think sorumor has it IBM is buying MySQL.
Mark
-Original Message-
From: Ignatius Reilly [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 31, 2004 6:38 AM
To: DB list PHP; Alireza Balouch
Subject: Re: [PHP-DB] Firebird
_
- Original Me
_
- Original Message -
From: "Alireza Balouch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 31, 2004 12:25 PM
Subject: [PHP-DB] Firebird
> It looks like firebird database is on its way to replace of mysql...
E???!!!???
How would you bac
"Julian Mesa" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I can compile doing 2 modifications, but doesn't work.
>
> I've had 2 modifications to compile interbase module of php:
> 1)in ibase.h add
> #define ISC_FAR
>
> 2) Before configure
> export LIBS="-lstdc++ -lcrypt -lcrypto"
