Error records affected

From: carlos (anonymous_at_discussions.microsoft.com)
Date: 02/25/04


Date: Wed, 25 Feb 2004 11:51:05 -0800

Hi!
I'm working with this code:
Set objCon = New ADODB.Connection
With objCon
    .ConnectionString = strMyOLEDBConnection
    .Open
end with
'Call to one DLL pasing objCon by ref, with one UPDATE, INSERT or DELETE
Call objSQL.fncLngEjecutarSql(strMySQL, objCon)
....
'And in the DLL
Public Function fncLngEjecutarSql(ByVal strSql As String, _
                                Optional ByRef objConAs ADODB.Connection) As Long
objCon.Execute strSql, lngRows
The SQL is executed OK (with many rows affected), but return 0 in lngRows, why?