""pimpaitalia"" <j.niewint@...> wrote in message
news:a9475u+7mv6@......

> sorry that I posted all this stuff...but why it is impossible for me=20
> to import this data(blob). For sure it will be something really=20
> stupid (since I am a beginner with interbase)...Some escape=20
> characters, blob-field def. are wrong ???
> Thanx in advanced...
>
> Conversion error from string "BLOB"
> Statement: INSERT INTO DOCUMENT VALUES("53365-
> 2002","5",NULL,"8","COMMISSIONE=20

Simply use Firebird instead of Interbase and it will allow you to insert and
update blobs directly from literal strings. For the most part, both engines
are compatible since they share the same original code released in year
2000.

Anyway, if you are inserting big number of records, the fast approach is to
prepare an insert statement once and keep feeding the parameters, then
execute and so on.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing