Subject | Re: firebird - post with changed TBlobField is very slow |
---|---|
Author | superkatchina |
Post date | 2004-12-09T00:00:17Z |
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 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& MS SQL
> 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
> Server
> Upscene Productions
> http://www.upscene.com