Re: [Firebird-odbc-devel] Alpha Five v10 and ODBC Driver 2.00.00.150

[Alexander P. <ale...@gm...>]

On 28.11.2010 5:34, web...@rw... wrote:
>
> I am trying to use ODBC Driver 2.00.00.150 with Alpha Five v10 to 
> access a Firebird 2.5 database.
>
> I get the following error when trying to save data to the server...
>
> Server side error updating row.
>
> Database API specific error
>
> Your database has returned the following error code and description to 
> Alpha Five.
>
> Consult your database documentation for further information.
>
> -4 - '[ODBC Firebird Driver]Sqlda variable has zero length
>
> SQL State is: HY000'
>
> Refresh the data to see the current server values.
>
> Note that this same ODBC driver works perfectly with Access 2003.
>
> Is this a problem with the ODBC driver or Alpha Five?
>
> Thanks, Bob
>
>
Alpha Five generates SQL queryies such as:
"UPDATE COUNTRY SET CURRENCY = ? WHERE (COUNTRY = ?)  AND (CURRENCY = ? 
OR CURRENCY IS NULL AND *? IS NULL*)"
Firebird ODBC driver does not support such query now.

For resolving the problem you can change the following parameter in the 
Active-Link table settings:
Base update statement on: *Primary key only*
You can use Custom update query too.

Regards,
Alexander
-- 
Alexander Potapchenko
Lead developer
LASP technology, http://www.lasptech.ru