ADO question

[Lafor]

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:

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

Isn't that what raises an error?

[Lafor]

?
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