Thank you, the code is running.
Now I have found out, that the problem is not the code. Because the
speed is slow with your code also. But the problem is the BDE. When I
use the ODO with direct ODBC-Connection then the code also my old ones
is running with the wind.

Is it possible to use the blobs fast with BDE? The program was from a
previous guy and I can not replace the DB-Connection so easealy.

Thank you,
Werner Hofmann

--- In firebird-support@yahoogroups.com, "agung wibowo"
<agung_firebird@H...> wrote:

> 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]