How would you do this

[loftty]

Hi All,

I open 5 tables like so

CurrentDatabaseName = "Qwest"
        
        rstQwest.Open "Qwest_Details", connQwest, adOpenKeyset
        
        rstQwest2.Open "Qwestname", connQwest, adOpenKeyset
        
        
        CurrentDatabaseName = "Weldspec"
        
        rstWeldspec.Open "Weldspec_Details1", connWeldspec, adOpenKeyset, adLockOptimistic
       
        rstWeldspec2.Open "Tester_Weldspec", connWeldspec, adOpenKeyset, adLockOptimistic
       
        rstWeldspec3.Open "newtable", connWeldspec, adOpenKeyset, adLockOptimistic

and it fails on this line as I have spelt it wrong.

rstWeldspec.Open "Weldspec_Details1", connWeldspec, adOpenKeyset, adLockOptimistic

What I want to be able to do is to print out the table name that has failed. I could have string and set it to the table name before I open each table. But thought there might be a better way of doing this as it is later on that I want show the result.

Thanks

Loftty

[Trunks]

Originally posted by loftty
What I want to be able to do is to print out the table name that has failed. I could have string and set it to the table name before I open each table. But thought there might be a better way of doing this as it is later on that I want show the result.

That would seem like the simplest solution to me. Especially since you want to use the name of the table later on, and not right when the error occurs.

[BodwadUK]

How would it know what table errored???

In error handing cant you catch the complaint in the err object and print err.description???

[Shaggy Hiker]

You could build the SQL statements out of a series of strings. When the error occurs, you could show the string that coincided with the error that occured. This would take a bit of bookkeeping to do things such as figuring out which line failed, but it would work. However, this is only slightly different from what you are suggesting anyways. The only difference would be that the string holding the tablename would be used in the SQL itself.