Page 1 of 1

SmartQuery and complex data type

Posted: Wed 08 Apr 2009 22:56
by pete
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.

Posted: Thu 09 Apr 2009 07:18
by Plash
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.

Posted: Thu 09 Apr 2009 10:00
by pete
Yes, I was using the direct mode connection. Is that a problem?

Pete.

Posted: Fri 10 Apr 2009 07:26
by Plash
The Direct mode does not support OBJECT data types.