>sergey,
>
>if i have a big command such a big sql...
>
>how can i do ?
>
>
>bernhart

Can you possibly break it into multiple statements? Something like

cSql1 = "Select ......(up to the first UNION)"
cSql2 = "Union Select ....(up to next Union)"
.
.
.

Then do your Execute(ConnHandel, cSql1 + cSql2 + ...) ?

I ran into a similar issue and just got into the habit of

cSql = Sql Statement or SP call
cParams1 = parameter list
cParams2 = continuation of parameter list
etc.