Updating BLOB fields

Article View: borland.public.interbase.sql

Article #859

Back to borland.public.interbase.sql Previous Next

#859

From: Bob
Date: Wed, 13 Jun 2007 04:40

17 lines
1131 bytes

When Updating BLOB fields in Interbase 7.5 using the following SQL
UPDATE RDB$TRIGGERS
SET RDB$DESCRIPTION = '1'
WHERE( RDB$TRIGGER_NAME = 'TRIG_TOTALSHIST_DELETE' )

I get the following.

ISC ERROR CODE:335544334    ISC ERROR MESSAGE:  conversion error from string 
"BLOB"

Why is this so?

How can I do this?

Kind Regards,

Robert.

Technical Details

Message-ID: <466f7522$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,11d68289541f47e3,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bob" <Bob@Bob.com>
Newsgroups: borland.public.interbase.sql
Subject: Updating BLOB fields
Date: Wed, 13 Jun 2007 14:40:22 +1000
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 203.206.159.118
Message-ID: <466f7522$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1181709602 203.206.159.118 (12 Jun 2007 21:40:02 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail