Subject Re: [IBO] TIB_Script-2
Author Helen Borrie (TeamIBO)
At 09:02 PM 19-02-02 -0800, you wrote:
>Hi all,
>Another question, with TIB_script I create my tables and insert some data
>into them with SQL insert
> VALUES(5,102);
>is it possible to insert into a blob field, BMP images with insert?

No, isql has never supported that. Basically, to insert data into a blob, you have to pass a blob in an SQL statement via a specialised API item (which IBO encapsulates for you in TIB_ColumnBlob). Scripts are plain-text and have no way to handle binary input data.

However, in Firebird RC1and forward, you *can* pass a string as direct input to a text blob (sub_type 1 only). That doesn't help with your BMPs though.

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at