Tornado Class Library

Special Topic - Local Text

There are 2 options to localize the Tornado system messages. 
  1. Partial Replacement - Specify (Number=New text,...) will enable partial replace. Only the ones listed are replaced.
  2. Full replacement - This is the same as #2 except N=same number of system messages.

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

 


Send comments on this topic.
Copyright 1998-2006 ASP-db