SQLite DB Engine NoErrorMode
NoErrorMode read/write property

Gets/Sets the error mode of the object.


b = object.NoErrorMode
object.NoErrorMode = value


The property is Boolean. True - no error mode, False - error mode.


Set db = Server.CreateObject("newObjects.sqlite.dbutf8")
db.NoErrorMode = True
If db.Open(Server.MapPath("/db/mydb.db")) Then
  Set r = db.Execute(qry)
  If db.LastError <> "" Then
    ' An error has occured - deal with it
    ' ...
    ' Display the results for example
    ' ...
  End If
  ' Deal with the error further
  Response.Write "Error occured: " & db.LastError
  ' ... 
End If


The default mode is error mode (the property is by default False). In most cases this will be good enough, but as some languages do not have error handling capabilities (for instance JScript 3.0 is the greater version available for Poscke PC) you may need to swithch the NoErrorMode on and check for error by checking the LastError property. 

Applies to: SQLite COM object

See also: Execute,LastError

Supported on:

Windows 95/NT and later
Windows CE 3.0 and later
Pocket PC/Windows Mobile 2003 and later
Windows CE.NET 4 and later


newObjects Copyright 2001-2006 newObjects [ ]