Subqueries and VBA

sdk development
1

Dear listers,
Is anybody knows how to get subqueries details from VBA macro? We are creating reports, which has to use a lot of similar complicated queries
with subqueries. And we want to create VBA macro which will multiplicate one first query (as “template” query) and then adjust these queries manually.
It is possible in VBA but I can not find how to get subquery object. Thanks,

Ilya Gusev
Consulting Service dpt.
URBANATECHNOLOGIES & TERN

Listserv Archives (BOB member since 2002-06-25)

2

This is something which I’m also interested in…

Walter

ilya wrote:

Dear listers,
Is anybody knows how to get subqueries details from VBA macro? We are creating reports, which has to use a lot of similar complicated queries
with subqueries. And we want to create VBA macro which will multiplicate one first query (as “template” query) and then adjust these queries manually.
It is possible in VBA but I can not find how to get subquery object. Thanks,

–
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at

Listserv Archives (BOB member since 2002-06-25)

3

It is my understanding that subqueries are not exposed in the Object Model. I have attempted to read and build subqueries into the Conditions collection unsuccessfully. I have logged this deficiency as an enhancement request with Business Objects.

Adios,
January

Ilya wrote:

Dear listers,
Is anybody knows how to get subqueries details from VBA macro? We are creating reports, which has to use a lot of similar complicated queries
with subqueries. And we want to create VBA macro which will multiplicate one first query (as “template” query) and then adjust these queries manually.
It is possible in VBA but I can not find how to get subquery object. Thanks,

–
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at

Listserv Archives (BOB member since 2002-06-25)