>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement