Subject | RE: [IBO] Insert BLOB Text |
---|---|
Author | Helen Borrie |
Post date | 2006-11-17T13:14:38Z |
At 08:04 PM 17/11/2006, you wrote:
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
> > 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