Devart Forums

Posted: **Tue 22 Sep 2015 12:48**

From your (delphi) example the new Batch Update Feature tells:

Query1.Params[0].DataType:=ftInteger;
Query1.Params[1].DataType:=ftInteger;
  
for i := 0 to Query1.Params.ValueCount - 1 do begin
    Query1.Params[0][i].AsInteger := i + 1;
    Query1.Params[1][i].AsInteger := i + 2000 + 1;
  end;

In c++ builder (xe8 pro), I can't use it .

Code: Select all

Query1->Params[0]->DataType:=ftInteger;

cannot be compiled. I have to write

Code: Select all

Query1->Params->Items[0]->DataType=ftInteger;

Hoping the effect is the same????

Also,

Code: Select all

Query1->Params[1][i]->AsInteger = i + 1;

raises an exceptionat runtime. I tried [1] but I also get exception.
I tried also

Code: Select all

    Query1->Params[i].Items[1]->AsInteger=i+1;

but it also fails.

Is it feasable to use this feature in c++?

KR,
Alain

Posted: **Wed 23 Sep 2015 05:14**

Hello,

Yes, this feature is supported in C++ Builder. You can use the following code:

Code: Select all

	OraQuery1->Params->ValueCount = 2;
	OraQuery1->Params->Items[0]->DataType = ftInteger;
	OraQuery1->Params->Items[0]->ParamType = ptInput;

	OraQuery1->Params->Items[0]->Values[0]->AsInteger = 1;
	OraQuery1->Params->Items[0]->Values[1]->AsInteger = 2;

	OraQuery1->Execute(2);

Devart Forums

batch update 9.6.20 c++ builder

batch update 9.6.20 c++ builder

Re: batch update 9.6.20 c++ builder