Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread update clob to emptystring
Thu, Dec 18 2008 5:57 AMPermanent Link

Heiko Knuettel
Hi

UPDATE table SET clobfield='test'  -> works
UPDATE table SET clobfield=null  ->  works

but

UPDATE table SET clobfield=''  ->  leaves clobfield as is

Heiko
Thu, Dec 18 2008 8:32 AMPermanent Link

Uli Becker
Heiko

> UPDATE table SET clobfield=''  ->  leaves clobfield as is

I couldn't believe it. Just tested it and: you are right.

Regards Uli
Thu, Dec 18 2008 2:55 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Heiko,

<< UPDATE table SET clobfield=''  ->  leaves clobfield as is >>

Yep, it's a bug.  A fix will be available in 2.02 B6.  It was caused by this
fix:

http://www.elevatesoft.com/incident?action=viewrep&category=edb&release=2.02&type=f&incident=2852

--
Tim Young
Elevate Software
www.elevatesoft.com

Image