Jason,
I bet the statement failed, because you did not specify how to order,
DESC or ASC.

I would download the beta pdf docs as that is one of the best sources
outside of the Borland media kit for $50. The pdf's are free and should
have most if not all of what you are looking for.

ftp://ftpc.inprise.com/pub/interbase/techpubs/ib_b60_doc.zip

On Thu, 2002-08-01 at 00:45, Jason Fischer wrote:
> Hi all.
>
> 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???
>
> The field does exist in the INSCOMPANY table. If I remove the order by it
> works fine.
>
> Please be patient with me. I am new to IB/Firebird.
> Thanks.
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone 707.766.9509
Fax 707.766.8989
http://www.obsidian-studios.com