Determine if Code Raises an Error

[Bonediggler1]

Hi-

In mid-module, how do i test if the following code raises an error, without tampering with the error handler already in place?

"dbs.execute ("select * from table1;")"

If IsError(dbs.execute ("select * from table1;")) = true doesn't seem to do the trick.

Ultimately I need to call a particular function based on whether the dbs.execute works or not.

Thank you!!

 

[Remou]

You cannot Execute a Select query, Execute is for Action queries only. Furthermore, you ned to use dbFailOnError to check for SQL problems.

That being said, if you want to check for an error, it is not uncommon to use:

On Error Resume Next
DoSomethingThatCausesAnError
If Err.Number>0 Then
   'Some problem
   Err.Clear
Else
   'Ok
End If

However, it is nearly always better to come up with a solution that avoids the error.

http://lessthandot.com

 

[TheAceMan1]

How are ya Bonediggler1 . . .

The [blue]execute[/blue] method is only valid for [blue]action[/blue] queries!

As far as testing [blue]Select[/blue] queries is concerned ... either they work or they don't!

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[Remou]

@TheAceMan1
I guess you missed the first line of my answer.

http://lessthandot.com