Subject RE: [IBO] Insert BLOB Text
Author Helen Borrie
At 08:04 PM 17/11/2006, you wrote:

> > I have an INSERT statement in a IBO Cursor. Using a parameter, I want
> > to assign text to BLOB field. However, when I execute the statement
> > the text doesn't end up in the BLOB. What could be wrong?
>
>Parameters are for input values and their values are not picked up as values
>for fields when they post.

??

insert into atable (id, somedata, aTextBlob)
values(:id, :somedata, :aBlob)

What I missed: "...in a IBO Cursor." If this means in an IB_Cursor
then the assignment isn't to a TDataset descendant, which makes it a
whole lot easier than I said, e.g., assigning the content of a TMemo
to a text blob parameter:

TIB_ColumnMemo(MyIB_Cursor.aTextBlob).Assign(MyMemo.Lines);

Do the assignment in the BeforePost.

Helen