Subject Re: [ib-support] SQL for Firebird
Author Martijn Tonies
Hi Jason,

> You are probably going to think that this is a terrible question,
> but where can I find the SQL syntax used for sql statements on firebird.
> I tried the following
> and got an error message saying that InsCode field/column not found???

Most probably you created the InsCode column case-sensitive - a nasty
habit I think ... This is called "quoted" or "delimited identifiers" - it
you to use reserved words, spaces and makes the identifiers case sensitive.
If you used the double quotes once, you need them always.

Try an ORDER BY "InsCode" - or drop the column and re-create it
case insensitive.

btw, this is exactly why my tool InterBase Workbench (which also works
with Firebird) has this behaviour turned OFF by default. You might
want to have a look at it.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."