Re: Updating BLOB fields

Article View: borland.public.interbase.sql

Article #868

Back to borland.public.interbase.sql Previous Next

#868

From: Wayne Niddery [TeamB]
Date: Thu, 14 Jun 2007 01:25

22 lines
1679 bytes

Bob wrote:
>
> I did this:
>
> UPDATE RDB$TRIGGERS
> SET RDB$DESCRIPTION = :THEDESC
> WHERE( RDB$TRIGGER_NAME = 'TRIG_TOTALSHIST_DELETE'

If this is actually copied from your code then you have a typo - missing 
closing parenthesis.

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

You should be able to assign this as a string:

 TSQLQuery.ParamByName('THEDESC').AsAsString := '1';


-- 
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"Nurture your mind with great thoughts. To believe in the heroic makes
heroes." � Benjamin Disraeli

Technical Details

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

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!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> <46709202@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
Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
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> <46709202@newsgroups.borland.com>
Subject: Re: Updating BLOB fields
Date: Wed, 13 Jun 2007 21:25:40 -0400
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 69.17.170.228
Message-ID: <46709916@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1181784342 69.17.170.228 (13 Jun 2007 18:25:42 -0700)
X-Authenticated-User: wniddery
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message