Invalid field type, BDE error $2710 when query a table with blob field


2004-06-05 04:38:24 AM
off-topic6
Hi, I am using BDE query /SQL explorer to run a query against a table
(Oracle database 9i), I got the invalid field type error: The table is like:
CREATE TABLE ATABLEWITHBLOB(
DISTDATA BLOB NOT NULL,
NID NUMBER(*, 0) NOT NULL,
)
My query is :
SELECT * FROM ATABLEWITHBLOB;
Thank you in advance for any advice.
Zhuo