Download TED4 (Include DotNet 1.0 and 1.1 - No ID file required)

• Editor - Introduction
• Release History
• Important patches and KB articles
• Installation
• Quick Start
• Shortcut Key Table
• Editor - Designer - FTP
• Designer - General
• Designer - Connection Form
• Designer - Display
• Designer - Navigation and TextHolder
• Designer - MagicCell
• Designer - Menu
• Designer - Upload
• Designer - Tree
• Designer - Inputs
• Designer - Chart

• Each version of TED comes with the exe file for DotNet 1.0 and 1.1.
   
• TED4 requires a new set of Ted.ini, TedCode.ini and TedSyntax.ini files. These files are included in the zip file. The Ted.ini file is the same as before but syntax and code .ini files is different.
   
• You MUST have ODBC.Net installed (O/S below WS2003) to use TED.
   
• MS has released the Patch for the RichText Undo Bug, please download at
  http://support.microsoft.com/default.aspx?scid=kb;en-us;812943
  essentially, replace the riched20.dll (system file) with the new one in 'safe' mode. The patched DLL works for W2K, XP and WS2003 as tested here. We reported this bug to MS a long time ago but their fix is not incorporated into any new releases. To make it convenient for our customers, here is the patch - Remember, do it at your own risk... Riched20.dll (422KB). Rename and keep the old copy (in safe mode) before replace.
   
• Put Ted4.exe and associated files in the equivalent of inetpub/wwwroot/bin directory assuming your IIS home is inetpub/wwwroot/. Mandatory - Setup your /Tornado/Scratch directory so you have write access. Ted looks for a valid Tornado id file (id3, id4 etc) in the /Bin sub-directory under the Tornado Physical Directory in the Preference Setup and also the directory which Ted?.exe resides on. If search fails then Evaluation mode will be activated.
   
• Check Help/About_TED to find out about version and expiration information of TED.
   
• Add command parameters to Ted4.exe to set version mode -> Ted4.exe /Gold or Ted4.exe /ep or Ted4.exe /office. Version initial mode is not available for the Free version. You can also pick the version mode under the 'Option' Menu.

TED (Tornado Editor & Designer) is a WinForm (.exe) utility available to ASPdb.Net users under a maintenance contract. Because programming web database applications with ASP-db requires 'NotePad Only' and VB6 or Visual Studio is optional. The Editor part of TED provides code editing functionalities and the Designer part provides code generation hence the entire process is 'Point & Click'. For those who is using Classic ASP-db. TED is the same except it offers an integrated Editor. We are usually the highlight of ASP trade shows when use this tool to perform 'live' sessions in manipulating live data brought to us from show audiences (and many times exhibitors)  while the others are showing presentation slides and pre-programmed examples. If ASP-db can be the highlight in such a demanding environment - imagine what you can do with in your environment.

The editor house the most current syntax of Tornado in an external file 'TedSyntax3.ini'. Another external file 'Tedcode3.ini' contains many unique examples. The purpose of these examples is to aid the debugging process. For example, it contains generic aspx files to access various datasource (Access, SQL, MySQL, Oracle etc.) such that when a user have difficulties in using Tornado with a particular datasource, he/she can use these simple generic code to verify the datasource setup.

it is expected that TED will be used in a localhost workstation with administrator access to the http server such that file scan be transferred in both up and down direction.

A file called 'Ted3.ini' contains the default setup of the Editor and the Designer.

A file called 'Designer3.ini' stores all the Designer form data.

Upon returning from the editor, the Editor will open the default preview aspx file generates by the Designer. A preview can be done in the Editor as well as the Designer.

Preview can be done in the localhost as well as remote configuration.

Special editing features - There are many programming editing tasks that is in my own wish list and cannot be found in any other editors. I take the opportunity to incorporate these functions and it helps me a lot. The magic text functions can turn a long typing session into a few point and click action.

• Compare to lists - can be vertical (one line per items and vertical lists separated by a blank line) or (Horizontal) two lines with one list per line delimited by commas. You can change this delimiter in the setup page.
   
• MagicText 2:1 - COnvert double spaced lines to single spaced lines.
   
• Magic Text #me# - line text - add any text before and after. For example each line contains a word like -
  one
  two
  three
  Magic Text of: Case "#me#": #me#.text = ri
  will produce -
  Case "one": one.text=ri
  Case "two": two.text=ri
  Case "three": three.text=ri
   
• Magic Text #extract# - extract text from each line. left and right wrappers can be different. For example
  This is line "one"
  This is line "two"
  Magic Text of: "Extract" will product
  one
  two
  "extract"=extract text enclosed by the character(s) before the word and after the word - in this case doubles quotes - if no wrapper then defaults to double quotes; If right wrapper missing then extract from Left wrapper to end; If left wrapper missing then extract from beginning to right wrapper.
   
• Magic Text #n:start# - prefix line with an index starting with start. For example each line contains a word like -
  one
  two
  Magic Text of: #n:1#. #me# will product
  1. one
  2. two
   
• Magic Text word:n - extract the nth word from the line. For example each line contains a word like -
  one two three four
  two three four five
  Magic Text of : word:3 will product
  three
  four
   
• Smart Sort (text, numeric, date) ASC/DESC - This function will sort the lines of the entire file or selected lines. Lines can have a numeric, date or normal text and it'll be detected and sorted accordingly. For numeric prefix can have append text like -
  

  4. item 4 5. item 5 For date, the entire line must be Cdate() valid like - 1/2/2003 Jan 2 1997 1/4/01 5-7-03 One Line sort - 4,1,2,5,7,3,45 will be sorted as 1,2,3, 4,5,7,45

   

• Split and Join - Split and join lines according to the delimiter in Setup page. Defaults to ",".
  
• Get dir filenames - dir:directory full path.
  e.g. dir:c:\inetpub\wwwroot\tornado\ted\*.resx
  
• Copy <Lf> and Copy <Cr><Lf> - Two different copy offered to allow paste text to different target.
  
   

• Clear active editor - Ctrl-E
• Cut/paste/type or load a test program
• Hit IE preview button and answer 'yes'
• File will be saved as preview.aspx in the scratch directory before preview
• Note that .aspx file can have any html code.

The following remote file transfer activities requires FTP server is running in the local development station -

• Open URL ascii file in editor
• Save editor file to URL
• Remote Preview editor file in browser (aspx, htm etc...)
• Remote Preview Designer Forms or ASPX code in browser

All activities use FTP setup parameters. The following is a standard sample of  FTP 'send' and 'get' -

The send routine is used to send editor files to the remote server. After the active file is uploaded to the remote directory, it can be executed in the browser via the  'Remote Preview URL'. DO not mix up Remote URLs (http://www....)  and local URLs (http://localhost/...)

cd c:\inetpub\wwwroot\tornado\scratch

1. ftp
2. open www.ftpserver.com
3. username
4. password
5. binary
6. get Designer.aspx
7. Bye

The get routine download the remote file to the scratch directory for editing.

FTP tab input

• Remote Preview URL - This URL + filename = complete preview url
• FTP virtual directory - For normal FTP setup, this is blank as user will be logging into the base of the home virtual directory. If the target directory (e.g. level1) is located below the default ftp directory then a 'cd level1' have to be added after 'binary'. then the cd path should be entered here.
• Remote Preview Filename - This is the filename of the preview file.
• FTP URL or IP - This the the value of step #3
• FTP account - This the the value of step #4

Note: FTP Password is encrypted and if it is left blank in the setup, it'll be prompted everytime.

Designer is designed for the Tornado programmer to quickly prototype the numerous properties and methods of Tornado. No error checking is incorporated for the obvious reason - it is a back end tool. For those who has been using the ASP-db Designer, Tornado Designer is just another version for Tornado (ASP-db.Net). It is more colorful and powerful because Tornado is much more than ASP-db. The fact that Designer is now combined with the ASP-db editor makes the entire programming process integrated.

Starts at Designer mode using a command line - Ted.exe /Designer3 (data file = Designer3.ini)

Starts at Ted mode - Ted.exe  (Configueration file = Ted.ini)

TedCode.ini - Tornado example files

Designer3.ini - Tornado Designer form data file. This is the system file name of the working file and cannot be changed. Copy this file to a separate name (Save As) if needed.

A 'Form/Open New Project' will delete this working file from disk creating a new project and the form data stored in memory will be erased.

A 'Clear Form' will reset the active form but the original data in memory is retained. A 'Reload' will restore to the form data or a 'Save' or 'Exit Form' will save the new form data. 'Exit Form' means the form lost its focus.

Ted is available only to maintenance subscribers. Due to the fact that every update and patch will be incorporated into TED first, a 2004 Designer for example will not work properly with a 2003 Tornado.DLL.

Notes:

• Always Refresh your browser to preview.
• Do not modify the ini files.

This form enables you setup your datasource connection. Primary datasources supported are - MS-SQL, Access, Oracle, MySQL, Excel, Paradox, DBase and Text. Different textboxes that applies to the specific datasource will have the backcolor painted with lightyellow.

This form enables you configure the look and feel aspects of the display.

This form is the setup the navigation buttons and textholder.

b5 (default setup) = Top, prev, next, bottom, reload

Text Holder - This property allows you to insert text into strategic locations.

Tornado MagicCell has several improvements -

• Pre-programmed display macros 
• More operators
• Inline field formatting - #field:length:Format#, #field:length# or #field:Format#

How to Use the Math Filter -

T.dbGridMagicCell="fi=Price| Mac=<<#Price#*50/100:C>> 50% Off!"

This MagicCell Macro process the #Price# field and display a 50% discount.

4 styles of menu are available  - Simple, Dropdown, Button and Tab. Refer to dbMenu in manual for details. Try the following to generate some menu example code.

Basic Menu

1. Fire up the Design Console and go to the Designer.
2. Click Menu in the left pane to display the Menu form.
3. Clear the Form if needed by clicking the New-F button.
4. Goto 'General' Tab and pick a pre-programmed style -> Gold and a menu style of "5".
5. Set Width to 200
6. Set Height to 15
7. Goto 'Menu Template' tab. A sample template will be displayed
8. Click 'Preview Menu'. Vola - You just created a 3 items menu.
9. Go back to the 'General' tab and change the Width to 50 and Height = 50. Also Check the Vertical checkbox. Click 'Preview Menu' again. No Change in the browser? Always click the 'Reload' button for a new preview. Now you got a vertical version of the same menu.

Dropdown Menu

1. Fire up designer and go to Menu form and General tab.
2. Select Type 2 (dropdown).
3. Select skin type = Gold.
4. Set width to 600.
5. Goto Menu Types tab and check 'Solid Arrows' and 3D border.
6. Goto 'Menu Template' and see the re-built sample template
7. Click 'Preview Menu'
8. Repeat with other options.
9. Goto 'Effect' tab; Click '3D' checkbox and preview.
10. Goto 'Bar - Pie' tab and check 'Text Labels on', 'Value Labels On', 'Percent Labels Off' and preview.

This is a stand alone form and no data from any other forms are needed. That includes the title, skin and mail options. For a quick start, all the defaults are listed in the form and all needed is a click of the 'Preview' button. Confirm the SavePath is valid in your server.

Chart applies to the Gold version only. Run TornadoInfo via -> Ted?.exe | Help | TornadoInfo. Go to the bottom of the browser display and confirm the display of a sample chart which signals a good installation. Make sure the TED files are in the /inetpub/wwwroot/bin directory.

Do not use the normal 'Preview' button to view chart output unless it is a Grid-Chart. Use 'Preview Chart'. To see chart code generated, do not hit the code button, hit the "E" button to return to Editor to view the most recent Designer3.aspx file.

Step-by-step DB Chart -

1. Activate TED; goto Designer; clear the session.
2. Goto 'Connection' tab; take ACCESS(OleDB) default datasource type; select Northwind.mdb from /tornado/db directory.
3. Click 'Build DSN'; click 'Get Tables'; select 'Orders' table.
4. Click 'Fields & dbSQL' tab; select 'CustomerID' and 'Freight' and click right blue arrow to pick as 'SQL Fields'.
5. Click 'Build dbSQL'; click 'blue IE' preview button and you'll see the grid display.
6. Click 'Chart' and goto 'DataSet' tab. 'DB' radio should be checked, Set # should be '0'.
7. Pick Chart Type 26; inspaect 'Set Value' drop box as it should contain all the SQL fields.
8. For Dataset #0, pick 'yValue' for 'DataSet' and 'Freight' as 'Set Value'; click 'Build Data Set' to register the selection.
9. Pick 'Labels' for 'DataSet' and 'CustomerID' as 'Set Value'; click 'Build Data Set' to register the selection.
10. Click 'Preview Chart'. Refresh browser if neccessary to view chart.
11. Go back to 'DataSet' tab; select '2=bar App' and preview; select '17-indBarApp' and 'Preview Chart'.
12. Goto 'General Shared' change 'Width' to 400; Set 'Plot area - Color to black'.
13. Goto 'Effects' tab; Set Chart 'BG Color' = black.
14. Goto 'Axis' tab; Check 'xAxisOption';  Check 'LabelColor' and set 'Value' to 'white' and click 'Build xAxis'.
15. Check 'yAxisOption'; Check 'gridOn' and 'tickOff' and click 'Build yAxis'; Check 'LabelColor' and set 'Value' as 'white' and click 'Build yAxis'; Check 'yAxisGridColor' and set 'Value' as 'white' and click 'Build yAxis'; Check 'yAxisGridColor' and set 'Value' as 'white' and click 'Build yAxis'.
16. 'Preview Chart' !!
17. To see the chart code, do not hit the regular code button, hit "E" to return to editor and the most recent Designer3.aspx file will be loaded.

Note:

• Axis Options and Parameters can be retrieved by selecting the Radios. Blank out the value or unselect the check boxes and then 'Re-Built' the Axis data by clicking the 'Build?Axis' button again will update the parameters.
• Blockout - When the data series is the 'row' or 'field (stack bar). There might be columns(s) to exclude like the label column. You have to adjust the title names if you blockout column > 0 (unusual case as you should exclude the dataset instead). Normally in DB there is no blockout as there is no label column 0. Only in Excel or Csv file that a column

Step-by-step User Chart -

1. Clear form
2. Select ChartType = 18; Check User Radio; Select 'Labels' from DataSet
3. Input a,b,c,d,e in the User data area and click 'Build Data Sets'.
4. Select yValues from DataSet and input 1,2,3,4,5 and click 'Build Data Sets'.
5. Select 3D from effects and then Click 'Preview Chart'.

Step-by-step StackBar chart -

While most chart plots X vs Y, Col vs Col, Row vs Row. A Stack chart plot utilize the entire grid including header and labels making the construction quite complex. A one-button solution in TED is provided for such complex charts. Up to the point of the chart creation, this one-button click will create a default chart parameters and all you have to do is to customize a few parameters (title, size etc.) to create the chart. The following Csv file represents a commonlayout of a stack chart. The 1st column is the bar/column legend, header is the label and the rest of the grid are stack chart data.

• Q812943 - The RichEdit Control Undo Information May Be Lost When the Control Retrieves Text (not May be Lost - it will be lost)
• Q816783 - ASP.NET Applications Experience Unexpected Behavior After Upgrade to 1.1 and W2003
• Q818016 - HOW TO: Deploy Applications That Are Built on the .NET Framework

• 1.2.04 - 2004 Version of TED does not require any ID file. New set of ini files are required.
• 1.1.04 - Paste can only paste 32K - Fixed. Add 'No WHiteSpace' button to search.
• 12.4.03 - Add Find and Replace text combobox support.
• 10.24 - Similar file names like abc.aspx and abc.aspx.vb conflicts and the one with shorter name is loaded - fixed.
• 7.19.03 - Upload added - example, syntax and doc. Only one click is needed.
• 7.16.03 - Tab menu added with example. This implementation includes the menu and display frame.
• 6.21.03 - Add color control to download.
• 4.29.03 - Port Tornado & TED to W2003. Tornado.dll works OK but c:\windows\system32\riched20.dll still not fixed in W2003. Replace this file with the working one (in safe mode) in order to have the editor's undo to work properly.
• 4.17.03 - Release TED for Beta.