At 12:51 AM 01-08-02 -0700, you wrote:

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

No, this won't be the reason for the failure. ORDER BY is ASC by default
(you never have to specify it). You only need to specify this param when
you want a DESC sort...

As Martijn said, it will be a case-sensitivity problem that will be solved
(immediately) by using quoted delimiters and (robustly) by rebuilding the
database without case-sensitive identifiers.

>I would download the beta pdf docs as that is one of the best sources
>outside of the Borland media kit for $50.

...or subscribe to the IBPhoenix CD and get a whole lot of useful stuff
including the Using Firebird manual and the Firebird Reference Guide...(but
no API Guide yet, William...)

heLen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
______________________________________________________________________