At 11:37 PM 21/02/2004 +0100, you wrote:

>Hi, thank you for your answer.
>
>I wasn't aware that the dialect in which the database were created had any
>influence on use of quotes and field names, when running queries in dialect
>3, but that may explain my problem.

It does. Dialect 1 is a "legacy" from InterBase 5 and supports only what
IB 5 supports. Dialect 3 is the "native" SQL language of Firebird. You
can get more information about differences (which are *very* significant)
by reading the Migration Guide (available from the Downloads>InterBase page
at www.ibphoenix.com )

>Regarding the interpretation of the status vector. I am using the message
>file which were installed with FB 1.5 RC7. The funny thing is that if I use
>"isc_sqlcode" and "isc_sql_interprete" I get another interpretation than if
>I use "isc_interprete".

They are three different functions, each transporting different levels of
information. For details, consult the API Guide.

Please start new threads when you move to a new topic.

^heLen