Recordset Problems

Databases
1

Hello all.
I am using this syntax to address the database :

Dim rs As RecordSet
rs = SQLDatabase.SQLSelect (“EXEC spName @P1, @P2…”)

rs may contain records, but rs.recordcount is ALWAYS -1

I tried to put rs in the method and count them using WHILE not Eof, and because I need to loop the recordset, at the end of the method, I used rs.movefirst. I got the recordcount, but then “MoveFirst” acted as MovePrevious, so my recordSet was positioned at the last record instead the first.

Any suggestion where I am mistaking?

2

I am guessing this is a SQL database that does not support RecordCount or any Move… other than MoveNext. See:

http://documentation.xojo.com/index.php/RecordSet

and

http://documentation.xojo.com/index.php/RecordSet.RecordCount

3

Most databases do not support those methods.