T
Tony
How can I tell if an ExecuteNonQuery was successful.
Thanks
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Marina
It returns the number of records affected by the query.
W
William \(Bill\) Vaughn
If you're executing a SP, you can setup and trap the RETURN value parameter.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
T
Tony
Sorry for being so dense on this but i can't find any way to do this.
There is no UpDateRec.Item.count or anything like that, that i can find?
SQL = "DELETE from EMail WHERE ID = " & GetID
cnString = New OleDbConnection("Provider=MicroSoft.Jet.OLEDB.4.0; Data
source= C:\MyData.mdb")
Dim UpDateRec As New OleDbCommand(SQL, cnString)
UpDateRec.Connection.Open()
UpDateRec.ExecuteNonQuery()
(i need something here to check records effected)
cnString.Close()
There is no UpDateRec.Item.count or anything like that, that i can find?
SQL = "DELETE from EMail WHERE ID = " & GetID
cnString = New OleDbConnection("Provider=MicroSoft.Jet.OLEDB.4.0; Data
source= C:\MyData.mdb")
Dim UpDateRec As New OleDbCommand(SQL, cnString)
UpDateRec.Connection.Open()
UpDateRec.ExecuteNonQuery()
(i need something here to check records effected)
cnString.Close()
M
Miha Markic [MVP C#]
Tony,
ExecuteNonQuery returns an int which is number of records affected.
Dim recAffected as integer = UpDateRec.ExecuteNonQuery()
ExecuteNonQuery returns an int which is number of records affected.
Dim recAffected as integer = UpDateRec.ExecuteNonQuery()