go to post Iryna Mykhailova · Mar 28 Points made by Enrico are 100% valid and you may need to consider them. In your case, because your column is not named, you can use GetData(n) to get the count: set sql = "SELECT COUNT(*) FROM "_tableName_" WHERE "_fieldName_">='"_fromDate_"' AND "_fieldName_"<='"_currentDate_"'" set resultset = ##class(%ResultSet).%New("%DynamicQuery:SQL") set SC = resultset.Prepare(sql) set SC = resultset.Execute(sql) write resultset.GetData(1) Obviously don't forget to check the statuses.
go to post Iryna Mykhailova · Mar 24 As far as I know training does not include certification but it will obviousely increase your chances to answer more questions correctly and thus receive certification. In any case, I would definitely recommend doing the offline course - it's money well invested.
go to post Iryna Mykhailova · Feb 20 Well deserved, congratulations! I always read your FAQ articles, useful stuff! Good luck with obtaining the black belt! Coming from a blue belt in Kung Fu 😁
go to post Iryna Mykhailova · Jan 22 I'm very honored to be among the best authors of the Developer Community in different nominations! Congratulations to everyone!
go to post Iryna Mykhailova · Dec 24, 2024 And once again I'm a Language luminary: Still, 6 articles aren't too bad 😉
go to post Iryna Mykhailova · Oct 11, 2024 Thank you for this suggestion. PS. Being fluent in Russian won't help in this case, because the interface is in Ukrainian 😁
go to post Iryna Mykhailova · Sep 30, 2024 Yeeeessss! Great news, can't wait to spend my points on stuff!