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, "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.
Matijn ... All totally incorrect information for a REAL SQL database. Backticks
are a bodge for MySQL only and not part of the SQL standard.
And Firebird is used for many systems worldwide and is a much better alternative
to many later database engines. Many Oracle users are porting over to Firebird
to reduce costs.
--
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
