CCS: Invalid Datatype with Oracle CLOB columns?

CodeCharge Studio

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

CCS: Invalid Datatype with Oracle CLOB columns?

Author

Message

george l.

Posted: 09/12/2002, 12:22 PM

I have been having problems trying to search a CLOB column in C.C.S. I keep getting errors similar to this:
ORA-00932: inconsistent datatypes
Query :"SELECT COUNT(*) FROM NOTIFS WHERE "NOTIF_TITLE" like '%D%' OR "NOTIF" like '%D%'"

Can someone tell me if Oracle CLOBs are supported using CodeCharge Studio?

Ron

Posted: 09/16/2002, 1:43 AM

George,
as I know CCS doesn't support BLOBs and CLOBs, only MEMO which is actually a varchar

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home | Search | Members | Register | Login