User bio
404 bio not found
Kyiv, Ukraine
Member since Feb 16, 2016
Posts:
Replies:
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.
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.
Open Exchange applications:
Certifications & Credly badges:





Global Masters badges:







Followers:
Following:
Iryna has not followed anybody yet.
Congratulations everyone! Great result.