sorry, i reposting this message, because i am not receive it in my inbox :)

try this, i'm not testing before, but it may be work :
with query1 do begin
close;
sql.Clear;
sql.Add(''update LZA_VERSION set ZIP_BLOB =:XZIP');
prepare;
parambyname('XZIP').LoadFromFile('c:\exblob.zip',ftBlob);
execsql;
end;

with regards,
agung

----- Original Message -----
From: superkatchina
To: firebird-support@yahoogroups.com
Sent: Thursday, December 09, 2004 7:00 AM
Subject: [firebird-support] Re: firebird - post with changed TBlobField is very slow



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




[Non-text portions of this message have been removed]