SQL Dialect failure with latest version

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
upscene
Posts: 306
Joined: Thu 19 Oct 2006 08:13

SQL Dialect failure with latest version

Post by upscene » Tue 17 Mar 2020 18:17

Hi,

Just installed the latest version. There's a bug with the SQL Dialect.

In previous version, Connection.SQLDialect was used to set the dialect for the connection and after connecting, Connection.DBSQLDialect is the returned database dialect. However, in the most recent version, DBSQLDialect always returns '3'.

This is wrong.

This raises warnings in software I use with InterBase.

Please release an update.

With regards,

Martijn Tonies

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: SQL Dialect failure with latest version

Post by oleg0k » Wed 18 Mar 2020 10:06

Hello,
Please specify exact version of your server.
Which dialect are you expecting to get, and which one do you actually get?

wbr, Oleg
DAC Team

upscene
Posts: 306
Joined: Thu 19 Oct 2006 08:13

Re: SQL Dialect failure with latest version

Post by upscene » Thu 19 Mar 2020 11:48

Tried on multiple server versions.
However, in the most recent version, DBSQLDialect always returns '3'.
Obviously, I was expecting '1' instead of '3'.

Connection.DatabaseInfo.DBSQLDialect seems to return the correct value and is different from Connection.DBSQLDialect.

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: SQL Dialect failure with latest version

Post by oleg0k » Thu 19 Mar 2020 14:33

Hello,
We have reproduced and fixed the issue. This fix will be included in the next build of IBDAC.

wbr, Oleg
DAC Team

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: SQL Dialect failure with latest version

Post by oleg0k » Tue 02 Jun 2020 17:07

Hello!
We are excited to let you know that we have released new versions of DAC products with support for RAD Studio 10.4, which also include the latest fixes.
They are available for download on our website.

wbr, Oleg
Devart Team

Post Reply