Redirect to an IRL according to the System Error/Warning/Message return code.

Product Version

Property Value

Obj.dbErrorRedirect="ErrorNumber=Redirect_URL|...."

QuickProp Keyword Abbreviation

Remarks

• MAIN = 100
• SMTP = 200
• EDIT = 300
• FILTER = 400
• UTIL = 500
• RECORDSET = 600
• DYNAMICLIST = 1000
• LOGIN = 1100
• REMOTE = 1200
• TEMPLATE = 1300
• TESTTABLE = 1400
• MAGICCELL = 1500
• SP = 1600
• TREE = 1700
• APPLET = 1800
• ORACLE = 1900
• COMMON = 2000
• SHOW = 2100
• GetData = 2300

Example

Run the code w/o the error redirect and the error message will indicate the error 612:2. You can then trap the error (612) and make a re-driect.

  Dim z2 As New Tornado.z
  With z2
    .dbQP = "U=2||D=NWind|Gdf=01,1,2,3|Th=Ti=Employee Table"
    .dbSQL = "Select * From employees where Employeeid = 99"
    .dbErrorRedirect = "612=http://www.aspdb.com"
    .ASPdbNET()
  End With

Example to perform error trap inside the aspx code -

  Dim Mydb As New Tornado.z
  Mydb.dbQP = "U=2|D=Nwindx| Q=Orders| TH=Title=Error"  'Nwindx.mdb does not exist
  On Error GoTo Handler
  Mydb.ASPdbNET()
Handler:
  If Err.Number <> 0 Then Response.Write(Err.Number & "-" & Err.Description)

See Also

z Class | Tornado Namespace | dbLocalText

---