Insert into Blob field in Interbase

Posted on 2002-06-03
Medium Priority
Last Modified: 2012-06-27
I am trying to insert records into an Interbase table using the SQL syntax: INSERT INTO TABLE(Field list) VALUES(Value list). My code is choking on the BLOB field. I get the error:

SQLState: HY000
Native Error Code: 335544334
conversion error from string "BLOB"

Please help!!

Question by:AmyWiles
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 280 total points
ID: 7053274
the BLOB fields cannot be inserted as usual fields, but need to be updated by chunks (AppendChunk) and also read by chunks (GetChunk).
You need to read some documentation about this, which is the same for all the databases with BLOB (or similar) data type. See here for ASP/Interbase/Blob sample:



Author Comment

ID: 7055151
Could someone please give me an example of writing text to a blob field? I am having a hard time finding any examples.

Expert Comment

ID: 9201608
Writing text to a BLOB field would be like

Recordset("fieldname").AppendChunk Fieldvalue

to retrieve,

Chunksize = Recordset("Fieldname).Actualsize
Fieldvalue = Recordset("Fieldname").GetChunk(Chunksize)

hope this helps, AmyWiles


Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question