Databases
StackOverflow2013
Postsdbo
POVB6 ADODB.Recordset RecordCount property always returns -1
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POVB6 ADODB.Recordset RecordCount property always returns -1
    primarykey
    data
    text
    <p>I am trying to get some old VB6 code to work with SQL Server Compact. </p> <p>I can connect, open the database and all seems well. I can run insert select commands which work. </p> <p>However the ADODB.Recordset RecordCount property always returns -1 even though I can access the Fields and see the data. Changing the CursorLocation = adUseClient causes a problem when executung the SQL (multiple-step operation generated errors).</p> <pre class="lang-vb prettyprint-override"><code>Option Explicit Private Const mSqlProvider As String = "Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;" Private Const mSqlHost As String = "Data Source=C:\Database.sdf;" Private mCmd As ADODB.Command ' For executing SQL Private mDbConnection As ADODB.Connection Private Sub Command1_Click() Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset Dim DbConnectionString As String DbConnectionString = mSqlProvider &amp; _ mSqlHost Set mDbConnection = New ADODB.Connection mDbConnection.CursorLocation = adUseServer Call mDbConnection.Open(DbConnectionString) If mDbConnection.State = adStateOpen Then Debug.Print (" Database is open") ' Initialise the command object Set mCmd = New ADODB.Command mCmd.ActiveConnection = mDbConnection mCmd.CommandText = "select * from myTestTable" mCmd.CommandType = adCmdText Set rs = mCmd.Execute Debug.Print rs.RecordCount ' Always returns -1 !! Debug.Print rs.Fields(0) ' returns correct data for first row, first col Debug.Print rs.Fields(1) ' returns correct data for first row, 2nd col Debug.Print rs.Fields(2) ' returns correct data for first row, 3rd col End If End Sub </code></pre> <p>Any advice would be gratefully accepted.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSysDragon
    1. USBelliez
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POVB6 ADODB.Recordset RecordCount property always returns -1
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POVB6 ADODB.Recordset RecordCount property always returns -1
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POVB6 ADODB.Recordset RecordCount property always returns -1
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload