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');
parambyname('XZIP').LoadFromFile('c:\exblob.zip',ftBlob);
prepare;
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




Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




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