ADO question

if I execute this within vb

ls_SqlString = "Update tblName & _
"Set Active = 'N' " & _
"Where FirstName = 'test'"

with ADO's .Execute

How can one check if the update statement was actually succesful or not...?

beside using the on error goto

thanks

Just to be sure:

Code:

---

ls_SqlString = "Update " & tblName & _
"Set Active = 'N' " & _
"Where FirstName = 'test'"

---

Isn't that what raises an error?

?
Sure, it should...

We have a weird case that we're dealing with here
where statement fails and with appearance of success
(no error)

Thanks