Page 1 of 1

TUniSQL and DML arrays

Posted: Thu 25 Oct 2012 08:29
by Guillaume
Hi,

Is it possible to use DML Arrays with TUniSQL (with Oracle provider), in order to execute n INSERT sql statement at a time (with n parameters) ?
I am talking about the feature that exists in the TOraSQL component, using ArrayLength property and Execute(RecCount) method.

If not,
- is there any chance to see this feature implemented in the future ?
- what is the purpose of the Execute(Iters: Integer) method ? It looks very similar, but I cannot find a way to specify different parameters for each iteration

Thanks for your answer

Re: TUniSQL and DML arrays

Posted: Thu 25 Oct 2012 11:15
by AlexP
Hello,

Using DMl Arrays is not supported in UniDAC , as it is a specific feature of Oracle, and it is not included to UniDAC. Server-specific features are implemented in separate products.
The Execute(Iters: Integer) method can be seen in UniSQL, since it is a public method in a basic class for both TOraSQL and TUniSQL.

Re: TUniSQL and DML arrays

Posted: Thu 25 Oct 2012 12:01
by Guillaume
Thanks for your answer, I understand.
Best regards