> -----Original Message-----
> From: Thomas Steinmaurer [mailto:ts@...]
> Sent: Monday, January 06, 2003 1:26
> To: ib-support@yahoogroups.com
> Subject: RE: [ib-support] Blob Field
>
> >
> > Could you let me have the correct SQL for the insert?
>
> You can't do that with an INSERT INTO statement directly.

It mean we can't insert binary data (i.e BMP File) using isql?

> You'll have to use a parametrized query in your client application.
>
> For example (using an IBO TIB_DSQL):
>
> with IB_DSQL1 do begin
> Close;
> SQL.Text := 'INSERT INTO ResGraphs (setupNo, ph1Graph)
> VALUES (:setupNo, :ph1Graph);'
> Prepare;
> ParamByName('setupNo').AsInteger := 1;
>
> ParamByName('ph1Graph').LoadFromFile('d:\multimedia\pictures\s
> ignature.bmp');
> Execute;
> end;
>

Can we do that using programming language other than delphi?

TIA

>
> HTH,
> Thomas Steinmaurer
> IB LogManager 2.1 - The Logging/Auditing Tool for InterBase
> and Firebird http://www.iblogmanager.com