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
> "SELECT * FROM INSCOMPANY ORDER BY InsCode"
> 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
allows
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
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

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