Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
update clob to emptystring |
Thu, Dec 18 2008 5:57 AM | Permanent 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 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |