Subject Re: firebird - post with changed TBlobField is very slow
Author superkatchina
Ok,

Do I have to use the TQuery? I wanted to try some code:
query.add('update LZA_VERSION set ZIP_BLOB = ...
query.filter = 'id = ' + id;
query.params[0].as(?) = ....loadFromFile('sample.zip');
query.prepare;
query.execute;

and now what do I have to do? Can you help me with the correct code,
because I do not know what I have to do exactly.

Thank you,
Werner Hofmann

> Do an INSERT INTO, prepare the statement, load
> the blob into the parameter, call Execute.
>
> Don't use .Post and .Edit.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL
& MS SQL
> Server
> Upscene Productions
> http://www.upscene.com