firebird, insert records using query window [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 4 months ago.

Improve this question

I have the database table AllowedFields with the following columns:

ID int
Name Varchar(50)
FieldRecord Decimal(7,2)

I am trying to insert demo records using the following query:

set term ^ ;
EXECUTE BLOCK AS BEGIN
INSERT INTO AllowedFields(Name, FieldRecord) VALUES ("A", 0.00);
INSERT INTO AllowedFields(Name, FieldRecord) VALUES ("E", 13.00);
END^

But I am getting this error message:

Engine Code    : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -206
Column unknown
A
At line 3, column 37

Obviously firebird sees this A value as a column value?

How would I change this script to insert a record. Thanks.

@mbeckish :) thanks, please post your comment as an answer, so I can accept it. — panjo
– panjo, Commented Jun 25, 2013 at 18:51
You can go ahead and give the credit to @a_horse_with_no_name. :) — mbeckish
– mbeckish, Commented Jun 25, 2013 at 19:39

user330315 · Accepted Answer · 2013-06-25 19:38:05Z

1

The SQL standard defines double quotes to denote identifiers (table names, column names, constraint names, ...). So "A" identifies a column named A and not a single character.

String literals have to be enclosed in single quotes in SQL. So you need to use 'A' to denote a string (character) literal.

Putting this together you need:

INSERT INTO AllowedFields(Name, FieldRecord) VALUES ('A', 0.00);
INSERT INTO AllowedFields(Name, FieldRecord) VALUES ('E', 13.00);

You should also be aware that the standard requires quoted names to be case-sensitive, so "A" is a different column than "a").

And Firebird follows the standard.

answered Jun 25, 2013 at 19:38

user330315

Sign up to request clarification or add additional context in comments.

1 Comment

Mark Rotteveel Over a year ago

There is an exception: if you are using the legacy dialect 1 instead of dialect 3, then double quotes can be used to delimit strings. However dialect 1 should be considered deprecated since Interbase 6 / Firebird 1 (2000ish)

Collectives™ on Stack Overflow

firebird, insert records using query window [closed]

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related