query = "SELECT omschrijving, partijhoedanigheid_id "+
"FROM partijhoedanigheid "+
"WHERE dossiercategorie_id IN ( "+
" SELECT dossiercategorie_id "+
" FROM designer_2_dossiercategorie "+
" WHERE designer_id = "+designer_id+" "+
" AND actief_f = 1 "+
" ) ";
dataset = databaseManager.getDataSetByQuery(currentcontroller.getServerName(), query, null, -1);
labelArray = dataset.getColumnAsArray(1);
rec_idArray = dataset.getColumnAsArray(2);
application.setValueListItems('variabelList4',labelArray, rec_idArray);
When the dataset is empty, I want a empty valuelist…but it doesnt.
Even using application.setValueListItems(‘variabelList4’,null, null); doesn’t set an empty valuelist.
It just remembers the previous query.
Is the expected behaviour?? Hope not…any other way to clear the valuelist?
Servoy Developer
Version R2 2.2.5-build 337
Java version 1.5.0_06-b05 (Windows 2000)