For this, you must use the SQLLinks supplied by BDE,
but depending on your DB schema and features used
from FB 1.5, INTRBASE SQLLink will not work.
Anyway, BDE+ODBC is lethally slow.

On Thu, 09 Dec 2004 12:11:30 -0000, superkatchina wrote:

>
>
>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]
>
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>