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
> }- Re: dynamic param count at SetArgs from %XML.DataSet Kristian Kalweit
- Re: dynamic param count at SetArgs from %XML.DataSet Kristian Kalweit
- Re: dynamic param count at SetArgs from %XML.Dat... Bill McCormick
