Laura Blázquez García view profile on InterSystems Developer Community

After executing your query, you need to move cursor and then you can get data:

SET SC = resultset.Prepare(sql) 
SET SC = resultset.Execute()
if (resultset.Next(.SC)) {
	quit:$$$ISERR(SC)
	set cnt = resultset.Data("CNT")
}
SET SC = resultset.Close()

go to post

Laura Blázquez ... · Mar 11

Thanks a lot to everyone for the support! 😊

go to post

Laura Blázquez ... · Mar 11

Thanks a lot for all your support! It's been a pleasure to participate 😊 And congratulations to everyone! I think it was a tough competition, all articles were so great!