Solved

Insert into Blob field in Interbase

Posted on 2002-06-03
3
1,524 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 70 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Query still returning duplicates 5 58
Hide cell in a table 2 42
Clear input text 15 32
Want an individual results display div 8 61
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

739 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