Subject | TIBQuery always return a read only resultset ? |
---|---|
Author | Dennis Cons |
Post date | 2002-09-11T15:52:52Z |
I have just moved from BDE to the IBX componet set in Delphi.
I need to insert a blob, which I have previously done by getting a BDE
resultset into insert mode (requestlive = true and open a select) , then
using
TBlobField(MyTfield).LoadFromStream(Stream) ......setting the TField
With TIBQUERY, I cannot get past "read only dataset"...trying to use
.INSERT or .EDIT methods , so I can set the Tfields and then POST.
I is sometimes very usefull to be able to get into EDIT or INSERT mode, just
assign values to the Tfileds and then post , instead of writing update sql
and then using EXECSQL.
How do you do this ... am I missing something simple.
Dennis Cons
I need to insert a blob, which I have previously done by getting a BDE
resultset into insert mode (requestlive = true and open a select) , then
using
TBlobField(MyTfield).LoadFromStream(Stream) ......setting the TField
With TIBQUERY, I cannot get past "read only dataset"...trying to use
.INSERT or .EDIT methods , so I can set the Tfields and then POST.
I is sometimes very usefull to be able to get into EDIT or INSERT mode, just
assign values to the Tfileds and then post , instead of writing update sql
and then using EXECSQL.
How do you do this ... am I missing something simple.
Dennis Cons