On Feb 6, 2008 9:27 AM, Michael Vilhelmsen
<Michael.Vilhelmsen@...> wrote:

> Hm - Maybe
>
> If I read it correctly you just confirm, what I said.
> That is the SQL send from this other application is not valid to Firebird.
>
> I Believe they send it like this:
>
> select * from [DWICountry]
>
> Where it should be
>
> select * from DWICountry
>
> At least I have never used those [] with any SQL written to Firebird.
> But I have used them with a MS SQL Server.
> And I know, that those people that has made this other appl. among
> others uses a MS SQL Server.
>
> But thx so far.
>
> Ill contact this other company now.
>
> Michael

Yes, that is correct. I was just trying to explain to you the
difference between MS SQL Server and Firebird. The [] are delimiters
for MS SQL Server identifiers. In Firebird the equivalent is "". But,
you should never have to use them, unless you have, for instance, a
keyword conflict. In that case, you declare your identifier delimited
between ""

if your table was created using the following sql:

create table DWICountry (column1, column2, etc...), then you can write
your selects in two ways:

Without delimiters:

1) select * from DWICountry
2) select * from dwicountry
3) select * from DWiCounTrY

which is case insensitive. All of the above will work.

Or, you can use delimiters and query it like this:

select * from "DWICOUNTRY"

Firebird stores the identifiers internally in uppercase, so if you do
use the delimiters, then you have to uppercase your identifiers.

Now, if you do something like this:

create table "DWICountry" (column1, column2, column3, etc...), then
Firebird will store it exactly like that, and you have to use the
delimiters all the time. That is:

select * from "DWICountry"

if you try:

select * from "dwCounTry" or select * from "dwcountry", this will not work.

In MS SQL Server, you replace the "" with [ and ]

All the best,

Fidel.