SQL - GetRows method fails when no records are returned

[Gorby7]

I'm using 3 easy SQL functions written by Locodarwin found here: They work great, I use the GetRows method to extract the results into a 2D array.

The problem comes when there are no records/rows returned. The GetRows method fails with a console output error of "The requested action with this object has failed" and "$aResults=$oResults.GetRows()^ ERROR". I cannot figure out a way to check to see if there no records before calling the GetRows method. I tried using the RecordCount method but it always returns -1 because the recordset is forward-only/read-only. I tried to UBound the results object, but of course that didn't work. Any ideas? Here's my code:

$oOpen=_SQLConnect("server","database",1,"sa","password")
$oResults=_SQLQuery($oOpen,"EXEC Stored_Procedure_Name")
$iColumns=$oResults.Fields.Count
MsgBox(0,"","Rows: " & UBound($oResults))
MsgBox(0,"","Rows: " & $oResults.RecordCount)
$aResults=$oResults.GetRows()
$iIndex=UBound($aResults)
_SQLDisconnect($oOpen)

[Gorby7]

By the way, I'm still on version 3.3.6.1.

[jchd]

A standard way to avoid hitting this wall if doing something like:

If Not $oResults.EOF Then
$aResult = $oResults.GetRows()
...
EndIf

[Gorby7]

That works perfectly! I can't believe I didn't think to try something with the EOF property after a whole day of Googling. Thanks a bunch.

[jchd]

You're welcome; glad it works as expected in your case.