TUniQuery and "Data type is not supported"

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
cbc700
Posts: 46
Joined: Fri 03 Aug 2007 17:25

TUniQuery and "Data type is not supported"

Post by cbc700 » Fri 08 Mar 2013 09:06

If a TUniQuery is used to query a database that has a field type that is not supported, it will throw an exception, mentioning "Data type is not supported".

An example of this are the XML fields in the Customer tables of the DB2 'sample' database.

I've written a browsing type of application and find that when exploring various tables, it is not even able to retrieve a single record when encountering such a field.

Is there some approach I can use to get around this? If not, is this something that can be addressed in the product?

Even if support for XML or any other unsupported field types cannot be handled, how about the simple idea of just creating a dummy field of the same name (maybe a varchar(1), maybe with all the row values as a single question mark) as a placeholder, and at least allow the query to complete? Maybe this should be an option, so as to now affect current functionality. Any solution would be better than the exception and no data.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: TUniQuery and "Data type is not supported"

Post by AlexP » Mon 11 Mar 2013 15:11

Hello,

We have added support for fields of the XML type. In the next version, such fields will be mapped as usual BLOB fields. For the time being, you can exclude unsupported fields from the query to avoid this error.
P.S. If you find other unsupported data types, please let us know, and we will investigate the possibility to implement support for them.

cbc700
Posts: 46
Joined: Fri 03 Aug 2007 17:25

Re: TUniQuery and "Data type is not supported"

Post by cbc700 » Thu 21 Mar 2013 11:22

Do we have a rough estimate of when the next build is coming? Thanks.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: TUniQuery and "Data type is not supported"

Post by AlexP » Fri 22 Mar 2013 08:22

Hello,

We plan to release a new version in the next month.

Post Reply