SQLite DB Engine NoErrorMode
 
NoErrorMode read/write property

Gets/Sets the error mode of the object.

Syntax:

b = object.NoErrorMode
object.NoErrorMode = value

Parameters:

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

Examples:

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
    ' ...
  Else
    ' Display the results for example
    ' ...
  End If
Else
  ' Deal with the error further
  Response.Write "Error occured: " & db.LastError
  ' ... 
End If

Remarks:

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 [ ]