Subject Re: [firebird-php] ibase_query(): Dynamic SQL Error SQL error code = -901
Author Lutz Br├╝ckner
Lester Caine wrote:

>>Another point worth checking is to use the correct database dialect in
>>ibase_connect().
>
> If it is not defined it SHOULD pick up the one in the database - is the
> EMPLOYEE database still dialect 1.

from the manual: dialect selects the default SQL dialect for any
statement executed within a connection, and it defaults to the highest
one supported by client libraries.

So it will usually default to dialect 3 these days.

The employee.fdb from the firebird 1.5 distribution is finally in
dialect 3. But the one from firbird 1.0 was dialect 1.

Lutz

--
web based Firebird and InterBase administration: http://www.ibwebadmin.net


[Non-text portions of this message have been removed]