Devart Forums

Using MyDAC 9.1.5 on RADS and this SQL
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

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.

Thanks bug request sent

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.