Hi,

any ideas ?

I have tried to get an information about
affected rows by an SQL Statement.

Dim lngRowsAffected As Long

If cnS44B6573.State = 1 Then
    cnS44B6573.Execute strSQL, lngRowsAffected, adCmdText
End If

strSQL is something like
UPDATE TABLE SET FIELD = 5

The statement is processed accurate but
lngRowsAffected is always -1 !?

Using:

VB6, VisualStudio, ADOx 2.6, MDAC2.6, MS JET 4.0, IBM AS/400 OLE DB Provider, AS/400 (DB2) V5R1

I had a similar problem once with the record count using ADO. What it came down to was I was using a Server Side Cursor. Just off the top of my head, I would ensure you are using a Client Side Cursor and see what the results are.

Larry Asher

Be sure that SET NOCOUNT ON has not been executed by any prior statements on the connection.

Be sure that the provider (AS/400) has not set this option behind your back...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

..dada..

I used Option:

adExecuteNoRecords

and it works

:o)