Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How can I modify the attribute value of property or field in ADO?

How can I modify the attribute value of property or field in ADO?

From: tornadoly <tu.xunjiang_at_zte.com.cn>
Date: Tue, 04 Nov 2003 01:52:00 -0500
Message-ID: <3556435.1067928720@dbforums.com>

hi all:

I think up a substitute way when the recordset-A that created by store procedure in ORACLE can't updatable:

if I use ADO-command object to set a sql statement for commandtext ,

I can get a recordset-B that can be updatebatch.

then I modify the attributes of the recordset-A through the value of the

attributes of the recordset-B.

I think that I will successful updatebatch the recordset-A if Its attributes

can be modify.

But:

in VC++6&ADO:

//the code is:

FieldPtr pField2 = updRecordset->GetFields()->GetItem(CComVariant(i));

//operation:

pField2->GetProperties()->GetItem(CComVariant(j))->PutValue(val1);

//or

pField2->GetProperties()->GetItem(CComVariant(j))-
>PutAttributes(adPropWrite);

//to modify the attributes of recordset-B,

but It is appear a error message:"Operation is not allowed in this context."

so why and how can I do?

best regards.

--
tornadoly


Posted via http://dbforums.com
Received on Tue Nov 04 2003 - 00:52:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US