Re: Firebird return wrong value
| From: | Matijn Woudt | Date: | Fri, 18 Jan 2013 13:11:05 +0000 |
| Subject: | Re: Firebird return wrong value | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-48653@lists.php.net to get a copy of this message | ||
On Fri, Jan 18, 2013 at 12:49 PM, <vberko@mail.com> 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