I'm trying to get Ado working with some Fox databases and keep getting 0 records. The State for both the connection & recordset objects is 1 after the open. I'm using a System DSN pointing to the DBC.
Here's the code:
oConn = CreateObject("ADODB.Connection")
oConn.Open("galsinc")
oRS = CreateObject("ADODB.RecordSet")
oRs.ActiveConnection = oConn
oRs.Source = "SELECT * FROM Customers"
oRs.Open
?oRs.ReccordCount
The last line always returns -1.
Grrrr....