SmartQuery and complex data type

pete · Post by **pete** » Wed 08 Apr 2009 22:56

I have table with SDO_Geometry column and have come across a problem when the table is edited through a TSmartQuery. Even though I return only the non-complex columns in the SQL, I get a "Data type is not supported" error.
When I convert to a TOraQuery with the same SQL, it all works fine.
Is this a bug or is it by design that you can't use a TSmartQuery on a table with complex data types?

Regards
Pete.

Plash · Post by **Plash** » Thu 09 Apr 2009 07:18

We could not reproduce the problem. Please send to odac*devart*com a complete small sample that demonstrates the problem, including the script for creating database objects.

Maybe you have used the Direct mode connection when you have tested with TSmartQuery.

pete · Post by **pete** » Thu 09 Apr 2009 10:00

Yes, I was using the direct mode connection. Is that a problem?

Pete.

Plash · Post by **Plash** » Fri 10 Apr 2009 07:26

The Direct mode does not support OBJECT data types.