Question:
How can retrieve the number of records that have been returned by a query?
Solution:
To do so, you must use the RecordSet‘s RecordCount property.
The example below shows a script, executed at a button on screen, showing the number of records returned by “QuerySearch” query:
Dim SearchID, aux, auxb
Set Search = Screen.Item("QuerySearch")
SearchID = Screen.Item("SetPointSearch").Value
Search.SetVariableValue "CID", BuscaID
Search .Execute(TRUE)
Set RS = Search.GetADORecordset()
MsgBox RS.RecordCount
Attachments:
