Re: Error records affected

From: Victor Koch ("Victor)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 17:22:46 -0300

Hola Carlos, proba agregandole el parametro adCmdText al llamar al metodo
Execute y dimensionado lngRows como Long.
Otro problema puede ser que el proveedor oledb no soporte esta opcion o
tengas que usar cursores del lado del cliente.

objCon.Execute strSql, lngRows,adCmdText 

--
Un saludo, Víctor Koch.
"carlos" <anonymous@discussions.microsoft.com> escribió en el mensaje
news:B2E0F6E3-F862-4EA6-B686-DE3C1C651C80@microsoft.com...
> 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?
>
>