Sorry the source I posted is not correct :-(

Right version:
>
> // Converting :param to ? and build paramlist
> set sqlparams = ##class(Reporting.WSQuery).ParseSQL(.qsql)
> Set result=##class(%XML.DataSet).%New()
> Do result.Prepare(qsql)
> if Params.Count()>0
> {
>    set args = "result.SetArgs("
>    For i = 1:1:sqlparams.Count()
>    {
>     set args = args_""""_Params.FindByName(sqlparams.GetAt(i))_""""
>     if i<sqlparams.Count()
>     {
>      set args = args_","
>     }
>    }
>    set args = args_")"
>    do @args
> }



Reply via email to