>Hi!
>
>I have a database in which i write & read out, using RemoteData control & ODBC. I ran up into a problem.
>How can i trap ODBC errors? For istance if there is a syntax error in sql statement, the ODBC pops up a dialog box, saying that. Is there a way to avoid this dialog box? I tried with On Error goto address, but that happens after ODBC reports the error. I read the help, no luck there, tho it does explain something about trapping errors, but there is no example included.
>
>Also, why wouldn't this work or any similar example using dim variable as rdo***** (copied directly from vb help)
>
>Dim er as rdoError
>On Error GoTo CnEh
>
>
>CnEh:
>Dim er As rdoError
> Debug.Print Err, Error
> For Each er In rdoErrors
> Debug.Print er.Description, er.Number
> Next er
> Resume Next
>
>
>
>The compiler stops at Dim er As rdoError line, saying no user defined type not definided.
>
>
>If anyone has any ideas at all. Please let me know!
>
>
>Alesh
Check the RDO Reference Lib. is used, or add a RDC on the form.
Kervin
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only