Unidac 7.4.12 Delphi XE2 MySQL Problem

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
wbjsoft
Posts: 24
Joined: Tue 08 Aug 2006 00:38

Re: Unidac 7.4.12 Delphi XE2 MySQL Problem

Post by wbjsoft » Wed 06 Feb 2019 01:22

Thank you. I will wait for!

wbjsoft
Posts: 24
Joined: Tue 08 Aug 2006 00:38

Re: Unidac 7.4.12 Delphi XE2 MySQL Problem

Post by wbjsoft » Fri 08 Feb 2019 13:27

Hello~ Any Progress?
I can not release my product. :(

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Unidac 7.4.12 Delphi XE2 MySQL Problem

Post by ViktorV » Fri 08 Feb 2019 14:45

We continue to investigate the problem based on the latest data and let you know as soon as we get any results. Unfortunately, we cannot tell you the exact time frame.

Bicks
Posts: 1
Joined: Tue 12 Feb 2019 14:18

SUBSTRING operator not recognized while open Uniquery

Post by Bicks » Tue 12 Feb 2019 15:01

Hello,
It's my first post. Excuse me, if it's not on the right place. I'm looking for an answer in the forum and not found anything witch can help in my situation.
I'm using unidac 7.2.7 on Embarcadero Delphi Tokyo
I'm opening an ACCESS database by uniconnection and uniquery.
Most of the SQL queries works fine.
But when I'm trying to use SUBSTRING operator in SQL:

Code: Select all

Select ID, SUBSTRING(Name,1,2) from table1
Recieve : ERROR: [Microsoft][ODBC Microsoft Acces driver] Undefined function SUBSTRING in expression.

When change SUBSTRING with LEFT operator

Code: Select all

Select ID, LEFT(Name,1,2) from table1

it's working fine.

Is it means that substring operator is not supported?

I have and another issue loading a table with changed field name. I got error when I try to open Tuniquery with the following SQL :

Code: Select all

SELECT ID,name Fname FROM table1
ERROR: [Microsoft][ODBC Microsoft Acces driver] Syntax error (missing operator in expression about query "Name Fname").

if SQL is like this:

Code: Select all

SELECT ID,name FROM table1
everything working.

I'll be gratefull if you help me with this problems.
M.Dimitrov

wbjsoft
Posts: 24
Joined: Tue 08 Aug 2006 00:38

Re: Unidac 7.4.12 Delphi XE2 MySQL Problem

Post by wbjsoft » Thu 14 Feb 2019 10:37

Hello, Any Progress in this case?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Unidac 7.4.12 Delphi XE2 MySQL Problem

Post by ViktorV » Thu 14 Feb 2019 14:30

We will set high-priority status to your question and inform you as soon as any results are available, but we can't tell any timeframe at the moment.

wbjsoft
Posts: 24
Joined: Tue 08 Aug 2006 00:38

Re: Unidac 7.4.12 Delphi XE2 MySQL Problem

Post by wbjsoft » Sun 17 Feb 2019 13:34

I found same blob problem in your mysql dbexpress drivers.

can you send me night build? (only blob bug fix )

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Unidac 7.4.12 Delphi XE2 MySQL Problem

Post by ViktorV » Tue 19 Feb 2019 10:04

We have answered you via e-mail.

wbjsoft
Posts: 24
Joined: Tue 08 Aug 2006 00:38

Re: Unidac 7.4.12 Delphi XE2 MySQL Problem

Post by wbjsoft » Thu 21 Feb 2019 15:51

Thank you.

I Installed your dbforge studio.
and I tested that query and query executed successfully.

dbforge studio process charset unicode even connection encoding property set euckr ?

Image

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Unidac 7.4.12 Delphi XE2 MySQL Problem

Post by ViktorV » Fri 22 Feb 2019 13:24

Thank you for the information. We fixed this issue with #42000 syntax error .
We have answered you via e-mail.

wbjsoft
Posts: 24
Joined: Tue 08 Aug 2006 00:38

Re: Unidac 7.4.12 Delphi XE2 MySQL Problem

Post by wbjsoft » Fri 01 Mar 2019 06:46

I Tested it.

and it works fine! Thank you!

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: Unidac 7.4.12 Delphi XE2 MySQL Problem

Post by ViktorV » Fri 01 Mar 2019 08:35

It is good to see that the problem has been solved.
Feel free to contact us if you have any further questions about our products.

Post Reply