Board index » delphi » inserting images via sql insert query

Mandar

Delphi Developer
Mon, 20 Jun 2005 13:30:20 GMT

inserting images via sql insert query

Hi
I am having a peculier problem. I am using the structure where in I pass sql insert query to Object as parameter which in tern call sql insert on interbase.
Now I want to store Image(*.ico) files as Blob. Is it possible to insert BLOB field value as a part of insert query?
How to tackle this problem.

Mandar

 
Bojidar Alexandro

Delphi Developer
Mon, 20 Jun 2005 19:06:51 GMT

Re:inserting images via sql insert query


Quote
Mandar wrote:
> Hi
> I am having a peculier problem. I am using the structure where in I
> pass sql insert query to Object as parameter which in tern call sql
> insert on interbase. Now I want to store Image(*.ico) files as Blob.
> Is it possible to insert BLOB field value as a part of insert query?
> How to tackle this problem.

> Mandar

You must use parametrized sql and pass your file as parameter.

--
Bojidar Alexanrov
Kodar Ltd.
http://www.Kodar.net

Jaroslaw Szop

Delphi Developer
Mon, 20 Jun 2005 19:15:39 GMT

Re:inserting images via sql insert query


Try this:

          qryIns->ParamByName("binary_file")->LoadFromFile(file_path,
ftBlob);
          qryIns->ExecSQL();

Jarek

Other Threads

1. Insert an image via TParam

2. Inserting Images into the database via delphi

3. insert image via stored procedure

4. inserting interbase query via DBGrid

5. How to change field value of inserted record in insert trigger for MS SQL

6. insert huge Blob insert Ms SQL Server

7. Inserting blob into UPDATE or INSERT SQL Stmt

8. generators, ibtable - Insert via SQL works , append/post doesn't

9. Inserting Blobs via SQL

10. How to do an Update query or a Delete Query or an Insert Query using D3