I feared it was something like that, but in my application I don't know the type of the fields @ designtime.
I hoped the lines:
Sender.DeclareQueryVariables( qry_Insert);
qry_Insert.Execute;
would solve this but aparently I have to loop over all the variables to test on CLOB and BLOB and...
Hi,
I've made a simple application (Oracle 10, Delphi 7) but having problems updating CLOB fields via an update qry.
I have created a table:
CREATE TABLE TBL_001
( TBL1_SEQ NUMBER(8,0),
FLD_MEM CLOB
, CONSTRAINT PBL1_PK PRIMARY KEY
(
TBL1_SEQ
)
)
And an application with...