This is pissing me off (AffectedRows)

[sebs]

Why would the recordset not return the number of rows affected, I have example in a book that show a select returning the number of rows selected !!

Public Function RunQuery(ByRef QueryString)
    Dim AffectedRows
        
    Set rs = conn.Execute("SELECT * FROM ve_forms ORDER BY title ASC" , AffectedRows, adCmdText)
        
    RunQuery = AffectedRows
End Function

Selecting for now in a MS Access database and I tested my queries and it does work.

Thanks

[the182guy]

you could try putting RETURN @@Rowcount in the sql statement, this will return a message like '13 row(s) affected'

[sebs]

Where in the statement, I never used the @@Rocount before.

But why is the AffectedRows not working, it's suppose too !!!

Thanks

[the182guy]

Im no expert on SQL but i read that you could put RETURN @@Rowcount at the end of the query so like 'SELECT * FROM ve_forms ORDER BY title ASC RETURN @@Rowcount