Conversion error from string "BLOB"

Thread View: borland.public.interbase.sql

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Vander Thu, 12 Dec 2002 04:52

#11223

Author: Vander
Date: Thu, 12 Dec 2002 04:52

8 lines
1136 bytes

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?

Thanks
Vander

Re: Conversion error from string "BLOB"

#11233

Author: 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."

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads