Status OK

and the cnt as empty (I am expecting the count)

-------------------------------

Set resultset = ##class(%ResultSet).%New("%DynamicQuery:SQL")
set sql = "SELECT COUNT(*) AS CNT FROM "_tableName_" WHERE "_fieldName_">='"_fromDate_"' AND "_fieldName_"<='"_currentDate_"'"  
SET SC = resultset.Prepare(sql) 
$$$LOGSTATUS(SC)
SET SC = resultset.Execute(sql)
$$$LOGSTATUS(SC)   
if (resultset.GetData(1)>0)
$$$TRACE("cnt="_resultset.GetData(1))

-------------------------------

Hi Eduard,

I have a scheduler task and associated class that works.

Class Sample.Util.CreateTask Extends (%SYS.Task.Definition, %Persistent)
{

Parameter PROPERTYVALIDATION = 1;

Parameter TaskName = "Sample.Util.CreateTask";

Method OnTask() As %Status
{
// Perform the logic
}

}

Is there a way to Enable or Disable the abbove task "CreateTask()" from an external function/Method/class ?