Re: Updating BLOB fields

Article View: borland.public.interbase.sql

Article #866

Back to borland.public.interbase.sql Previous Next

#866

From: Bob
Date: Thu, 14 Jun 2007 00:55

32 lines
1772 bytes

Oh ok,

I did this:

UPDATE RDB$TRIGGERS
SET RDB$DESCRIPTION = :THEDESC
WHERE( RDB$TRIGGER_NAME = 'TRIG_TOTALSHIST_DELETE'

TSQLQuery.ParamByName('THEDESC').AsBlob := '1';
TSQLQuery.ExecSQL;

Uing DBExpress.

Kind Regards,

Robert.



"Bill Todd" <no@no.com> wrote in message 
news:4670883d$1@newsgroups.borland.com...
> Bob wrote:
>
>> Tried this
>
> I assume you mean that you tried a parameterized query. Since using
> parameters to assign strings to blob fields works for others it migt be
> helpful if you showed us the SQL that failed, the code you used to
> execute the SQL and identified the components you used.
>
> -- 
> Bill Todd (TeamB)

Technical Details

Message-ID: <46709202@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feeder2.cambrium.nl!feed.tweaknews.nl!xlned.com!feeder1.xlned.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<466f7522$1@newsgroups.borland.com> <466ff814$1@newsgroups.borland.com> <46701067$1@newsgroups.borland.com> <46707afb@newsgroups.borland.com> <4670883d$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,11d68289541f47e3
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bob" <Bob@Bob.com>
Newsgroups: borland.public.interbase.sql
References: <466f7522$1@newsgroups.borland.com> <466ff814$1@newsgroups.borland.com> <46701067$1@newsgroups.borland.com> <46707afb@newsgroups.borland.com> <4670883d$1@newsgroups.borland.com>
Subject: Re: Updating BLOB fields
Date: Thu, 14 Jun 2007 10:55:29 +1000
Lines: 34
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: <46709202@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1181782530 203.206.159.118 (13 Jun 2007 17:55:30 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feeder2.cambrium.nl!feed.tweaknews.nl!xlned.com!feeder1.xlned.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message