Index: vhDeploy/Deploy20200319SFSKalenderAanpassenDoorSluitingCorona.cls.xml =================================================================== diff -u -r60334 -r60337 --- vhDeploy/Deploy20200319SFSKalenderAanpassenDoorSluitingCorona.cls.xml (.../Deploy20200319SFSKalenderAanpassenDoorSluitingCorona.cls.xml) (revision 60334) +++ vhDeploy/Deploy20200319SFSKalenderAanpassenDoorSluitingCorona.cls.xml (.../Deploy20200319SFSKalenderAanpassenDoorSluitingCorona.cls.xml) (revision 60337) @@ -14,14 +14,16 @@ 1 = '2020-03-19' AND DeliveryDate < '2020-04-07'" + Set DateTimeAPI = $$$Inject(DateTimeAPI, ##class(TECH.DateTime.impl.DateTimeAPI).%New()) + #dim Params As %List = $LB(DateTimeAPI.CurrentDate()) + #dim Filter As %String ="OrderDate >= '2020-03-19' AND DeliveryDate < '2020-04-07'" #dim SqlTableName As TECH.String = ##class(TECH.CompiledClassUtils).GetSQLTableName(DataClassName) #dim SqlStatement As TECH.String = "DELETE FROM " _SqlTableName _" WHERE " _Filter Do ##class(Tools.Wlip).%New(43).String("SqlStatement: -"_SqlStatement_"-") Set DynamicQuery = ##class(TECH.DynamicQuery).%New(SqlStatement) - Set DynamicQuery.RuntimeMode = ##class(TECH.enu.ResultSetRuntimeMode).Logical() + Set DynamicQuery.RuntimeMode = ##class(TECH.enu.ResultSetRuntimeMode).ODBC() #dim QueryAPI As TECH.Query.QueryAPI = ##class(TECH.Context).Instance().GeefQueryAPI() #dim ResultSet As TECH.ResultSet = QueryAPI.GetResultSet(DynamicQuery) ]]>