SetOnSqlExceptionSub


SetOnSqlExceptionSub n, onSqlException()

(n) is the database file number.

Sets the on Sqlite exception subroutine. Once set, the specified onSqlException() subroutine will be automatically called when the error or exception occurs.


Const Sql_No_Problem = 0
Const Sql_File_Already_Open = 1
Const Sql_Error_Opening = 2
Const Sql_Error_Closing = 3
Const Sql_Not_Open = 4
Const Sql_No_Columns = 5
Const Sql_Exec_Error = 6
Const Sql_Insert_Error = 7
Const Sql_Update_Error = 8
Const Sql_Delete_Error = 9
Const Sql_Foreign_Key_Constraint = 10


Sub onSqlException(n, errorCode, msg$, extra$)

' Insert your code here

End Sub

SetOnSqlExceptionSub n, Off

Turns off the automatic subroutine call.


Event Triggered Subs







Become a Patron