ADO + PostgreSQL + BLOB fields !!!

From: Nikola (zjolovic_at_ptt.yu)
Date: 12/15/04

  • Next message: Michael Jacobs: "Re: How to Pass date parameters to Oracle using TADOQuery" 
    Date: 15 Dec 2004 05:30:21 -0800

    How can I extract file from BLOB field using ADO components?

    I've managed to insert file into database with the following
    code:

    ADOQuery1.Parameters.AddParameter.Name:='MyFile';
    ADOQuery1.Parameters.ParamByName('MyFile').LoadFromFile('d:\SomeFile.txt',ftBlob);
    ADOQuery1.SQL.Add('INsert INTO public."MyTable" (MyField) VALUES (:MyFile)');
    ADoQuery1.ExecSQL;

    I would be gratefull for any help...

                                   Nikola

  • Next message: Michael Jacobs: "Re: How to Pass date parameters to Oracle using TADOQuery"

    Relevant Pages

    • Re: ADO + PostgreSQL + BLOB fields !!!
      ... >How can I extract file from BLOB field using ADO components? ... >I've managed to insert file into database with the following ... Brian Bushay ...
      (borland.public.delphi.database.ado)
    • Re: ADO + PostgreSQL + BLOB fields !!!
      ... James West ... >>How can I extract file from BLOB field using ADO components? ...
      (borland.public.delphi.database.ado)