MyDAC Error on Concat() in RADS

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
yimmasabi
Posts: 2
Joined: Thu 24 May 2018 03:43

MyDAC Error on Concat() in RADS

Post by yimmasabi » Thu 24 May 2018 03:54

Using MyDAC 9.1.5 on RADS and this SQL

Code: Select all

"SELECT (@T:=duration-x) as T,  if( @T>0, concat(@T,' days'), 'DONE') as ETC FROM database;"
works well on first Table, Open() but after Close() and Open() again or Execute() in C++ Builder

I receive this ERROR on runtime:

"MyQuery1: type mismatch for field 'ETC', Expecting:WideMemo actual: String'"

In the first Open it works but when you close and open again it gives this error. BlobType is also "ftWideMemo"

bug or any idea ?

CAST(if( @T>0, concat(@T,' days'), 'DONE') as CHAR) as ETC also doesnt help




ok final test:

concat(@T, 'days') results as TMemoField and it outputs error
concat(cast(@T as CHAR), 'days') concat('zzz ', 'days') results TMemoField and it outputs error
concat('zzz ', 'days') results as TStringField and it outputs no error

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

Re: MyDAC Error on Concat() in RADS

Post by ViktorV » Thu 24 May 2018 06:33

For faster investigation of the problem and to be able to give you a detailed answer, please compose a full sample demonstrating the issue and send it to us via e-support form: https://www.devart.com/company/contactform.html including scripts for creating and filling in the database object.

yimmasabi
Posts: 2
Joined: Thu 24 May 2018 03:43

Re: MyDAC Error on Concat() in RADS

Post by yimmasabi » Fri 25 May 2018 22:49

Thanks bug request sent

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

Re: MyDAC Error on Concat() in RADS

Post by ViktorV » Tue 29 May 2018 10:31

In the sent sample there are not enough scripts to create the rest of the database objects.
Please send us scripts for creating and filling database objects to provide you a more detailed answer.

Post Reply