?
Solved

Insert into Blob field in Interbase

Posted on 2002-06-03
3
Medium Priority
?
1,533 Views
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!!

Amy
0
Comment
Question by:AmyWiles
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 143

Accepted Solution

by:
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:

http://www.sibprovider.com/en_us/faqs.asp#008

CHeers
0
 

Author Comment

by:AmyWiles
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.
0
 

Expert Comment

by:dwhelp
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

0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

765 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