Subject | RE: [IBO] IBO Blob usage |
---|---|
Author | Jason Wharton |
Post date | 2004-11-18T18:06:16Z |
Use a TIB_DSQL component instead of a TIB_Query component if is all you are
doing is inserts.
Take a look at the BlobInserts sample application for an example of how to
do parameterized inserting of Blob columns.
Params[n] are a TIB_Column and it supports doing an Assign( s: TStream ) and
then you just call the ExecSQL method after assigning all the blob contents
and other parameter values.
MyDSQL.Prepare;
MyDSQL.ParamByName( 'ACOL1' ).AsInteger := <some val>;
MyDSQL.ParamByName( 'ACOL2' ).Assign( <some stream> );
MyDSQL.ExecSQL;
HTH,
Jason Wharton
www.ibobjects.com
doing is inserts.
Take a look at the BlobInserts sample application for an example of how to
do parameterized inserting of Blob columns.
Params[n] are a TIB_Column and it supports doing an Assign( s: TStream ) and
then you just call the ExecSQL method after assigning all the blob contents
and other parameter values.
MyDSQL.Prepare;
MyDSQL.ParamByName( 'ACOL1' ).AsInteger := <some val>;
MyDSQL.ParamByName( 'ACOL2' ).Assign( <some stream> );
MyDSQL.ExecSQL;
HTH,
Jason Wharton
www.ibobjects.com