Re: How to get the ADO Connection 's RecordAffected Value
From: Norton (nortonwong_at_hotmail.com)
Date: 07/20/04
- Next message: Ivan Debono: "Re: Hierarchical Recordset"
- Previous message: Mathias Pihl: "Re: DAO to ADO"
- In reply to: Val Mazur: "Re: How to get the ADO Connection 's RecordAffected Value"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Jul 2004 18:07:50 +0800
Thx for your help ~
Regards,
Norton
"Val Mazur" <group51a@hotmail.com> wrote in message
news:OzRnlBgbEHA.2544@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> You cannot get multiple record affected values. I think most likely
provider
> will return the number of the affected records for the last statement (I
> could be wrong), so iRecordAffected variable should contain it. If it does
> not work and you need to get it, then you would need to execute statement
> separately
>
> --
> Val Mazur
> Microsoft MVP
>
>
> "Norton" <nortonwong@hotmail.com> wrote in message
> news:OLP2bxuaEHA.1248@TK2MSFTNGP11.phx.gbl...
> > Hi All,
> >
> > I am trying to execute multiple SQL Statement in one Connection.Execute
> > Method
> >
> > Such as
> > Dim sSQL as String
> > Dim iRecordAffected as integer
> >
> > sSQL = DeleteSQL & vbcrlf & InsertSQL
> > oConn.Comet.Execute(sSQL , iRecordAffected )
> >
> > How can i get the insert statement's Record Affected Value?
> >
> > Thx in advance
> > Regards,
> > Norton
> >
> >
> >
>
>
- Next message: Ivan Debono: "Re: Hierarchical Recordset"
- Previous message: Mathias Pihl: "Re: DAO to ADO"
- In reply to: Val Mazur: "Re: How to get the ADO Connection 's RecordAffected Value"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
