Re: Conversion error from string "BLOB"

Article View: borland.public.interbase.sql

Article #11233

Back to borland.public.interbase.sql Previous Next

#11233

From: Martijn Tonies
Date: Thu, 12 Dec 2002 13:09

29 lines
1699 bytes

Hi,

You cannot directly update/insert a blob.

Either create a prepared statement and use parameters or use an
UDF to convert the string data to a blob.

Both solutions can be found by using www.google.com


> Delphi 4 - IB6.0.2 - W98
> Hi guys
>
> I've got this error when I try to insert or update a blob field (subtype 1 -
> I use it to store 32K formated text ). What can I do to solve it?


--

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

Technical Details

Message-ID: <3df889d9@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!diablo.theplanet.net!diablo.netcom.net.uk!netcom.net.uk!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3df816a1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,c780216480346f1a
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-12 05:22:20 PST
From: "Martijn Tonies" <m.tonies@upscene_remove.com>
Newsgroups: borland.public.interbase.sql
References: <3df816a1@newsgroups.borland.com>
Subject: Re: Conversion error from string "BLOB"
Date: Thu, 12 Dec 2002 14:09:25 +0100
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 212.238.179.102
Message-ID: <3df889d9@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1039698393 212.238.179.102 (12 Dec 2002 05:06:33 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!diablo.theplanet.net!diablo.netcom.net.uk!netcom.net.uk!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message