Getting <no_result> from getDataSetByQuery method

Classic Servoy
1

Hi everybody, I can’t stand the following.
When I try to execute the ```
getDataSetByQuery

var _dipCatSql = " SELECT DISTINCT idDip FROM LF_ControlliChiusura(?,?)"
var _dipCatArr = new Array()
_dipCatArr.push(forms.giorn_header.idditta)
_dipCatArr.push(globals.getPeriodo())

var _dipCatDs = databaseManager.getDataSetByQuery('server_name',_catSql,_dipCatArr,1000)

if (_dipCatDs.getMaxRowIndex() > 0){...}


the variable ```
_dipCatDs
``` assumes the value "<no_result>". It gives no exception neither in the console nor in the servoy log.
I'm currently using the com.microsoft.sqlserver.jdbc.SQLServerDriver driver but I've also tried with the net.sourceforge.jtds.jdbc.Driver with no success.
The query runs correctly if called from a SQL Server Editor.
What am I getting wrong?
Thx in advance.
2

Maybe because you are declaring _dipCatSql and using _catSql ?

3

That’s could be the point… :oops:
Don’t worry, I am only a couple of weeks far from holidays.