Note
| Partial Replacement |
|---|
Obj.dbLocalText = "Num=YourMessage | Num=YourMessage |..... repeat"
e.g. Obj.dbLocalText = "0=My Error| 4=Great Success"
| Full Replacement |
|---|
Add a user defined message string to Application("UserMsg") in the Global.asax file with each corresponding field delimited by the global delimiter "|". To verify the addition of the UserMsg string - execute the TornadoInfo.aspx test file ->
<%
Dim MyTest As New Tornado.Z
Mytest.TornadoInfo()
%>
If the glaobal.asax file contains the user defined UserMsg then it'll display a comparison table. Use this information to guarantee the accuracy of the user table. It is recommended that you cut and paste the standard system list in the example and use overwrite mode to make changes.
| System Message Table |
|---|
| Index | Message |
|---|---|
| 0 | Error |
| 1 | Debug |
| 2 | Message |
| 3 | Warning |
| 4 | Success |
| 5 | Property Syntax Error |
| 6 | System Error |
| 7 | File I/O Error |
| 8 | Error Reading File |
| 9 | Reserved |
| 10 | Active SQL |
| 11 | Add MagicValidation failed |
| 12 | Blank DB detected - Action |
| 13 | Cannot Open datasource - <P>[Back] button to continue |
| 14 | Cannot perform Edit in SP |
| 15 | Cannot resolve CountSQL <P>You must supply dbCountSQL<BR>[Back] button to continue |
| 16 | dbRemoteURL is blank |
| 17 | dbSkin Error - cannot be blank and should be 'none' |
| 18 | dbUpdateROCriteria syntax error |
| 19 | Debug - Field Attributes |
| 20 | Debug - Filter Criteria |
| 21 | Edit Action SQL |
| 22 | Edit Setup SQL : |
| 23 | Edit SQL |
| 24 | Records match the criteria |
| 25 | Invalid Block Name |
| 26 | Error in connection |
| 27 | Error in DBType Property - Tornado FREE supports ACCESS only |
| 28 | Error in Edit - Edit BookMark not found |
| 29 | Error in Edit - Invalid BookMark |
| 30 | Error in Edit - Invalid Grid Update BookMark |
| 31 | Error in LocalText - Total replacement count mismatch |
| 32 | Error in Mail-To statement |
| 33 | Filter Crit |
| 34 | Forgot Password - ID cannot be blank |
| 35 | Full Screen Add MagicValidation Failed |
| 36 | Full Screen Update MagicValidation Failed |
| 37 | Hit [Back] button to continue |
| 38 | Invalid |
| 39 | Invalid Field(s) |
| 40 | Invalid Action - Not Logged in |
| 41 | Invalid Action - Try Again |
| 42 | Invalid Attachment File(s) |
| 43 | Invalid BLOB Field |
| 44 | Invalid Dynamic List SQL Level |
| 45 | Error in Line |
| 46 | Invalid filter Field |
| 47 | Invalid Goto or Empty Recordset<P>Hit [Back] button to continue |
| 48 | Invalid Login |
| 49 | Invalid Login Property Params |
| 50 | Invalid Logout |
| 51 | Invalid LookUp file |
| 52 | Invalid LookUp file (missing name) |
| 53 | Invalid LookUp file (missing values) |
| 54 | Invalid Mail-From address |
| 55 | Invalid New Email Address |
| 56 | Invalid New Password |
| 57 | Invalid Property Params |
| 58 | Invalid QP Properties |
| 59 | Invalid Query<P>Hit [Back] button to continue |
| 60 | Invalid result set |
| 61 | Invalid Silent Command Execution |
| 62 | Invalid stored Procedure result set |
| 63 | Invalid URL parameter |
| 64 | Invalid user email address |
| 65 | Invalid Values |
| 66 | Logout Successful |
| 67 | Max. Login Exceeded - Contact System Administrator for help |
| 68 | Missing Index parameter in Obj.dbCommonTables |
| 69 | Multiple Login Prohibited |
| 70 | Password is sent |
| 71 | Property Syntax |
| 72 | Records Added |
| 73 | SuperGoto EOF error - No matching data |
| 74 | SuperGoto input error - Invalid column/field - try again |
| 75 | SuperGoto input error - try again |
| 76 | Test Blank Table Connection Error |
| 77 | Test Blank Table Data Source Open Error |
| 78 | Unable to Open |
| 79 | Unable to write XML file |
| 80 | Unbalanced wrapper or Invalid Tag |
| 81 | Unknown tag |
| 82 | Update MagicValidation failed |
| 83 | XML file generated |
| 84 | You must supply dbCountSQL<P>[Back] button to continue |
| 85 | Login |
| 86 | No Matching Record(s) |
| 87 | Native |
| 88 | Source |
| 89 | SQL |
| 90 | Error in Localtext |
| 91 | Session Timeout |
| 92 | Invalid Macro |
| 93 | Error - Get Record Count |
| 94 | Error - Invalid Input Data Type |
| 95 | Error - Invalid SQL |
| 96 | Error - Invalid DSN |
| Use Code to Replace Local Text |
|---|
<script language="VB" runat=server>
Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)
Application("USERMSG") = UserMSG
End Sub
Public Const UserMSG =
"Error|" & _
"Debug|" & _
"Message|" & _
"Warning|" & _
"Success|" & _
"Property Syntax Error|" & _
"System Error|" & _
"File I/O Error|" & _
"Error Reading File|" & _
"Reserved|" & _
"Active SQL|" & _
"Add MagicValidation failed|" & _
"Blank DB detected - Action|" & _
"Cannot Open datasource - <P>[Back] button to continue|" & _
"Cannot perform Edit in SP|" & _
"Cannot resolve CountSQL <P>You must supply dbCountSQL<BR>[Back] button to continue|" & _
"dbRemoteURL is blank|" & _
"dbSkin Error - cannot be blank and should be 'none'|" & _
"dbUpdateROCriteria syntax error|" & _
"Debug - Field Attributes|" & _
"Debug - Filter Criteria|" & _
"Edit Action SQL|" & _
"Edit Setup SQL :|" & _
"Edit SQL|" & _
"Records match the criteria|" & _
"Invalid Block Name|" & _
"Error in connection|" & _
"Error in DBType Property - Tornado FREE supports ACCESS only|" & _
"Error in Edit - Edit BookMark not found|" & _
"Error in Edit - Invalid BookMark|" & _
"Error in Edit - Invalid Grid Update BookMark|" & _
"Error in LocalText - Total replacement count mismatch|" & _
"Error in Mail-To statement|" & _
"Filter Crit|" & _
"Forgot Password - ID cannot be blank|" & _
"Full Screen Add MagicValidation Failed|" & _
"Full Screen Update MagicValidation Failed|" & _
"Hit [Back] button to continue|" & _
"Invalid|" & _
"Invalid Field(s)|" & _
"Invalid Action - Not Logged in|" & _
"Invalid Action - Try Again|" & _
"Invalid Attachment File(s)|" & _
"Invalid BLOB Field|" & _
"Invalid Dynamic List SQL Level|" & _
"Error in Line|" & _
"Invalid filter Field|" & _
"Invalid Goto or Empty Recordset<P>Hit [Back] button to continue|" & _
"Invalid Login|" & _
"Invalid Login Property Params|" & _
"Invalid Logout|" & _
"Invalid LookUp file|" & _
"Invalid LookUp file (missing name)|" & _
"Invalid LookUp file (missing values)|" & _
"Invalid Mail-From address|" & _
"Invalid New Email Address|" & _
"Invalid New Password|" & _
"Invalid Property Params|" & _
"Invalid QP Properties|" & _
"Invalid Query<P>Hit [Back] button to continue|" & _
"Invalid result set|" & _
"Invalid Silent Command Execution|" & _
"Invalid stored Procedure result set|" & _
"Invalid URL parameter|" & _
"Invalid user email address|" & _
"Invalid Values|" & _
"Logout Successful|" & _
"Max. Login Exceeded - Contact System Administrator for help|" & _
"Missing Index parameter in Obj.dbCommonTables|" & _
"Multiple Login Prohibited|" & _
"Password is sent|" & _
"Property Syntax|" & _
"Records Added|" & _
"SuperGoto EOF error - No matching data|" & _
"SuperGoto input error - Invalid column/field - try again|" & _
"SuperGoto input error - try again|" & _
"Test Blank Table Connection Error|" & _
"Test Blank Table Data Source Open Error|" & _
"Unable to Open|" & _
"Unable to write XML file|" & _
"Unbalanced wrapper or Invalid Tag|" & _
"Unknown tag|" & _
"Update MagicValidation failed|" & _
"XML file generated|" & _
"You must supply dbCountSQL<P>[Back] button to continue|" & _
"Login|" & _
"No Matching Record(s)|" & _
"Native|" & _
"Source|" & _
"SQL|" & _
"Error in Localtext|" & _
"Session Timeout|" & _
"Invalid Macro|" & _
"Error - Get Record Count|" & _
"Error - Invalid Input Data Type|" & _
"Error - Invalid SQL|" & _
"Error - Invalid DSN"
</Script>
| Replace Local Text in Global.asax |
|---|
Sub Session_Start(ByVal sender As Object, ByVal e As EventArgs)
Dim UserMSG As String = "Error|" & _
"Debug|" & _
"Message|" & _
"Warning|" & _
"Success|" & _
"Property Syntax Error|" & _
"System Error|" & _
"File I/O Error|" & _
"Error Reading File|" & _
"Reserved|" & _
"Active SQL|" & _
"Add MagicValidation failed|" & _
"Blank DB detected - Action|" & _
"Cannot Open datasource - <P>[Back] button to continue|" & _
"Cannot perform Edit in SP|" & _
"Cannot resolve CountSQL <P>You must supply dbCountSQL<BR>[Back] button to continue|" & _
"dbRemoteURL is blank|" & _
"dbSkin Error - cannot be blank and should be 'none'|" & _
"dbUpdateROCriteria syntax error|" & _
"Debug - Field Attributes|" & _
"Debug - Filter Criteria|" & _
"Edit Action SQL|" & _
"Edit Setup SQL :|" & _
"Edit SQL|" & _
"Records match the criteria|" & _
"Invalid Block Name|" & _
"Error in connection|" & _
"Error in DBType Property - Tornado FREE supports ACCESS only|" & _
"Error in Edit - Edit BookMark not found|" & _
"Error in Edit - Invalid BookMark|" & _
"Error in Edit - Invalid Grid Update BookMark|" & _
"Error in LocalText - Total replacement count mismatch|" & _
"Error in Mail-To statement|" & _
"Filter Crit|" & _
"Forgot Password - ID cannot be blank|" & _
"Full Screen Add MagicValidation Failed|" & _
"Full Screen Update MagicValidation Failed|" & _
"Hit [Back] button to continue|" & _
"Invalid|" & _
"Invalid Field(s)|" & _
"Invalid Action - Not Logged in|" & _
"Invalid Action - Try Again|" & _
"Invalid Attachment File(s)|" & _
"Invalid BLOB Field|" & _
"Invalid Dynamic List SQL Level|" & _
"Error in Line|" & _
"Invalid filter Field|" & _
"Invalid Goto or Empty Recordset<P>Hit [Back] button to continue|" & _
"Invalid Login|" & _
"Invalid Login Property Params|" & _
"Invalid Logout|" & _
"Invalid LookUp file|" & _
"Invalid LookUp file (missing name)|" & _
"Invalid LookUp file (missing values)|" & _
"Invalid Mail-From address|" & _
"Invalid New Email Address|" & _
"Invalid New Password|" & _
"Invalid Property Params|" & _
"Invalid QP Properties|" & _
"Invalid Query<P>Hit [Back] button to continue|" & _
"Invalid result set|" & _
"Invalid Silent Command Execution|" & _
"Invalid stored Procedure result set|" & _
"Invalid URL parameter|" & _
"Invalid user email address|" & _
"Invalid Values|" & _
"Logout Successful|" & _
"Max. Login Exceeded - Contact System Administrator for help|" & _
"Missing Index parameter in Obj.dbCommonTables|" & _
"Multiple Login Prohibited|" & _
"Password is sent|" & _
"Property Syntax|" & _
"Records Added|" & _
"SuperGoto EOF error - No matching data|" & _
"SuperGoto input error - Invalid column/field - try again|" & _
"SuperGoto input error - try again|" & _
"Test Blank Table Connection Error|" & _
"Test Blank Table Data Source Open Error|" & _
"Unable to Open|" & _
"Unable to write XML file|" & _
"Unbalanced wrapper or Invalid Tag|" & _
"Unknown tag|" & _
"Update MagicValidation failed|" & _
"XML file generated|" & _
"You must supply dbCountSQL<P>[Back] button to continue|" & _
"Login|" & _
"No Matching Record(s)|" & _
"Native|" & _
"Source|" & _
"SQL|" & _
"Error in Localtext|" & _
"Session Timeout|" & _
"Invalid Macro|" & _
"Error - Get Record Count|" & _
"Error - Invalid Input Data Type|" & _
"Error - Invalid SQL|" & _
"Error - Invalid DSN"
Application("USERMSG") = UserMSG
End Sub