Subject Re: Can't connect with my ODBC driver
Author lysander_fb
--- In firebird-support@yahoogroups.com, "mona yazbeck"
<mona.yazbeck@h...> wrote:
> And about the quoted identifier, in fact, I don't really know what it
> means. But I develloped my program on my computer with a DNS having
quoted
> identfier and did not have any problem.

The setting in the DNS is not important until you indeed HAVE quoted
identifiers in your database; for that you must yourself CREATE them
first.

Those 3 queries are the same:
select * from MyTable
select * from mytable
select * from MYTABLE

Those 3 queries are running against 3 different tables:
select * from "MyTable"
select * from "mytable"
select * from "MYTABLE"

You already get the idea, I think.
Using quoted identifiers ONCE forces you to use them ever and again
and absolute correctly to avoid errors and exceptions.

ciao,
André