Tornado Release History

• Beginning 2008, all updates will be delivered to the subscription users directly via email. No need to check the site for update downloads any more.
   
• No need to place the ID file into the /bin dir. No need to rename the id file to Tornado.idx. Now, you can place the id file anywhere under any name. All old defaults are honored. The following are all valid values (see online doc) -
  
  x.dbIdFileDir = ""
  x.dbIdFileDir = "C:\Users\Frank\ID\bull_1_of_2_2008_Gold_id8"
  x.dbIdFileDir = "C:\Users\Frank\ID\bull_2_of_2_2008_Gold.id8"
  x.dbIdFileDir = "/mysite1/bin"
  x.dbIdFileDir = "/mysite1/bin/Tornado.id8"
  x.dbIdFileDir = "d:\t2005\mysite1\bin"
   
• Add DB2 native support to Tornado Gold version. This is a big item. Not until now, the data provider provided by IBM is fully functional.  IIS developers can expand their development boundary to cover IBM-DB2. Using Tornado GOLD, all your application aspx code will be re-usable for DB2. All you need to do is to change the dbType and dbProvider.
   
• Re-do Add Provider MYSQL = MYSQLCLIENT. MySQL is now supporting SP & functions and is in a more serious mode. We decided to revive the support. SP is not supported until MYSQL 6 in the new Ted08 while Tornado.dll does support that.
   
• New Ted - Ted08 with more flexible features and easier to use. Supports DB2 and MYSQL. Ted08 uses all native clients for all DBs.
   
• Separate DLL into SQL, MYSQL, ORACLE, DB2 and All-in-one so user can pick the appropriate one for their development w/o carrying the unwanted dlls.
   
• Fix EditDate format such that dbEditDate Format must be the default culture or defined by dbCulture. Example code to implement Germany de-DE date -

   Dim SP As New Tornado.z
   SP.dbQP = "u=1| s=2| M=ty=dh!sys=t| Q=customer | Dt=mysql |   Pv=mysql| gdf=0| bm=customer;0| ni=b5,update| th=tit=MySQL - Sakila DB"
   SP.dbEditUpdateFlds = "create_date"
   SP.dbEditDateFormat = "dd.MM.yyyy"
   SP.dbDSN = "ultra;sakila;frank;z"
   SP.dbCulture = "de-DE"
   SP.ASPdbNET()
 

• Enable multiple SQLs execution in silentcmd. Remember do not use CONNECT in SQLs. CONNECT is already done in Tornado when dbDSN is specified. Just specify the SQL statements.
   
• Add support for dbSQL = "File=....". ALl the SQL statements are stored in a local file instead of inline.
   
• Use dbSQL if dbSlentCmdText is not available. Example -
  
  <script language='vb' runat='server'>
  Sub Page_Load(Source as Object, E as EventArgs)
  Dim x As New Tornado.z
  x.dbQP = "u=1|dt=DB2|pv=DB2Client|D=localhost;TEST1;Frank;z"
  x.dbSQL = "file=/mysite1/SQLCmd.txt"
  Response.Write("Command execution returns (" & x.ASPdbExecuteCmd() & ") rows")
  End Sub
  </script>
   
• Add new parameter FilterHeader=false to Mode to turn off filter label.
   
• Make AllCase applies to Filter value. DB2 and Oracle will break when they are in Upper case mode.
   
• Implement Multiple select in filter. Use (SB+M) in SELECT ok now as '1,2' will be replace by '1 Def_Oper 2' in the SUBMIT. Normally, multiple select is for filtering A or B or C. Example -
  
  Dim x As New Tornado.z
  x.dbQP =  "u=1| q=orders| D=Nwind| Ni=b5,Filter,ResetFilter| Gdf=0,1,2,3| TH=tit=Filter Test| fc=OR"
  x.dbMode = "Ty=dh| FormHeader=f| filterheader=f| SysInd=t| IndFld=0"
  x.dbCommonTables = "ind=OID|Q=SELECT DISTINCT OrderID from orders"
  x.dbFilterFlds = "Fi=0|ty=SB+M|Val=OID|Def=10251, 1"
  x.ASPdbNET()
   
• Re-instate ASPdbUserChart. Note that remote files if used must be of valid MIME type (.data = no good; .html = ok)
   
• Implement dbBLOB for DB2. Remember that you can use Auto' to let Tornado to find out what type of BLOB the record contains. Therefore you can mix BLOB types in the table.
   
• dbInstallDir Init value not valid - fixed. Add support for CSS htpp:// css file location
   
• dbBlob manual for mix inline type is incorrect. Auto blob type detect is for inline display.
   
•  Add user controlled property 'dbSelectExactSQL' to accurately retrieve the exact amount of records for display. See online manual. Example -
  
  Dim x As New Tornado.z
  x.dbQP = "u=1| dt=DB2| pv=DB2Client|  D=localhost;SAMPLE;Frank;z| th=tit=IBM DB2-9"
  x.dbSelectExactSQL = "SELECT * from EMPLOYEE fetch first [[Top]] rows only"
  x.dbSQL = "SELECT * from EMPLOYEE"
  x.ASPdbNET()
   
• GetData breaks when return value is null - fixed - now returns blank string.
   
• Add DB2 support - Pv=DB2Client; Dt=DB2. DB2Client has similar structure as MS-SQL
   
• Add User Validate Js. Instead of using Tornado's validator, user can just add their Js validation routine. See example in online manual .dbValidaterParams.
  
  .dbValidatorParams = "code=/tornado/Jars|entry=false| UserValidateJs=checkselect(thisform)"
   
• Add ID=Fieldname or Fieldname_y (y=row #) to all input elements to be accessed by user Js. Instead of using Tornado's internal NAME and ID, user can now ID=fieldname to access the form variable in their validation Js.
   
•  Incorrect parsing of extended magic macro in the case of (#,###.0) macro with (..). For example -

 x.dbMagicCell = "(~?[]!|~/+{})fi=1| mac=(!1!  |LTN|0|align=right|<font color=red>!1:#,###.0;(#,###.0)!</font>~|EL||align=right)"

   will break the parser. Now - Fixed !!

• Add focus to bring THUMB to the front.
   
• Add Mono (mono spacing) font to EP
   
• Make dbPopText memo popup window stays focused. Also delete [[Memo]] from GridTemp when dbPopText is active as they are XOR.
   

• Add AJAX to Tornado in obj.ASPdbNet(Ajax=t). See doc in code api page.
• Enable mix Ajax=true in quick code
  Dim x As New Tornado.z
  x.ASPdbNET("D=NWIND | Q=Orders | Ajax=t")
   
• Note - Use ULTRA/SQLEXPRESS as server in SQLEXPRESS; Use SQL Server and Window Authentication mode for security.

• SP when getall and not specified dbResultSet returns incorrect grid(s).
• .dbOptions = "EditTitle = none" eliminates default title. Param "none" is case sensitive - fixed.
• Add DLL version and ID file name to the TornadoInfo.
• Add control to prohibit action title - see below example.
• Implement MAXLENGTH for TEXTAREA.
  MAX INPUT LEN Example -
  Dim ed As New Tornado.z
  With ed
  .dbQP = "U=3|M=g!sysind=t|S=2|D=NWIND|Q=orders|gdf=0,1,2,4 ,8,9,10,11|Ni=b5,update|bm=orders;0"
  .dbEditUpdateFlds = "fi=0|ty=ronoup,1,fi=2|ty=text|tag=maxlength=1 "
  .dbOptions = "EditTitle = none"   'prohibit title
  .ASPdbNET()
  End With
  
  Dim ta As String = "<script language='javascript' type='text/javascript'>" & vbCrLf
  ta &= "<!--" & vbCrLf
  ta &= "function MaxArea(Obj, MaxLen)" & vbCrLf
  ta &= "{" & vbCrLf
  ta &= "return (Obj.value.length <= MaxLen);" & vbCrLf
  ta &= "}" & vbCrLf
  ta &= "-->" & vbCrLf
  ta &= "</script>" & vbCrLf
   
• MAX TEXTAREA ->
  Dim ed As New Tornado.z
  With ed
  .dbQP = "U=3|M=g!sysind=t|S=2|D=NWIND|Q=employees|Ni=b5,up date|gdf=0,1,2,notes|bm=employees;0"
  .dbEditUpdateFlds = "(+^~)fi=0|ty=ronoup^1^fi=notes|ty=textarea|tag=ro ws=5 cols=20 onkeypress='return MaxArea(this, 15);'"
  .dbOptions = "EditTitle = none"
  .dbSendHead = ta
  .ASPdbNET()
  End With

• Access2007 and Excel2007 supported. Ag.exe is also updated. Goto MS site and download the ACE.OLEDB engine and copy the Northwind 2007.accdb sample db and you'll be in business.
• The Classic Edit Add special functions are available using dbButtonsOnOff - check it out.

• Suppress css when mm=t.
• Yahoo stock returns N/A instead of 0.0. Adjust ASPdbGetStockTicker() to handle that.
• Add new Oracle boolean field update example in Doc

• Add new feature GetFieldMatrix to retrieve SQL fields properties. Result returns in a 2-Dim array.

• Add new feature ASPdbGetStockTicker, dbStockTicker and dbStockTickerTemplate.

• Dynalist level with one item cannot be selected - fixed.
• Add dbOptions="EditTitle=None" to strip edit header
• Example of retrieving raw data
• dbLogin missing ? - fixed

• Add dbDowloadParams = "striphtmltags=t| downloadtitle=Excel Download Title"
• Add SP and Agg download support - all models
• LargeDownload incorrect 'Return' address - fixed
• Arrest missing id file error - unusual but happens.
• Arrest CrLf at end of id string - Users are editing the id file which they are not suppose to. A CrLf is left at th eend and blows up the parsing. Now fixed.
• Support latest MySQL 5 syntax.

• SP does not cover download - fixed.
• Add notify = receipt mail address to email
• SP out variable limited to (1) - fixed.
• Mix of user operator and normal oper blows up filter query - fixed.
• Enable TimeStamp GridUpdate grid by adding a new property dbGridUpdateSumbitModifiedRowOnly.

• Useragreement incorrect link fixed.
• Delete selecteditem turned off after edit/cancel - fixed.
• Allow user to use queries with conflicting 'AND' operator like filter string -> 'Quality Laundry and Books'; 'Barnes And Nobles'. Just enclose the search phrase with embedded AND with single quote.
• Tornadoinfo works 1st time but reload crash - fixed.
• GridEditMagicCell failed when startup = edit - fixed
• Get_RSCOUNT <> 0 when Search returns 0 record - fixed.
• Search Filter not registered in Get_RSCOUNT - fixed.
• Filter non-range dropdown not working - fixed.
• Download top record pointer set to 0 to get the whole download.
• Patch MS-SQL GROUP BY dbCountSQL = Select Count(1) FROM (Select ... GroupBY ....) As X
• ASP 2.0 DLL included.

• New Tornado API manual in www.aspdb.com/tornadomanual/index.html. You can download the Tornado.chm file (www.aspdb.com/tornadomanual/tornado.chm) which has all the text and code but w/o live execution. All codes in this new API manual works with the latest July DLL.
• Access + ODBC not work - fixed.
• Add Quick Open in ASPdbNet. Obj.ASpdbNet("D=Nwind|Q=Employees"0 will perform a quickopen with navigation, search and memo handling.
• EditGridUpdate incorrect in Startup Mode. Add dbStartUp="EditGridUpdate". Since Normal and Grid edit is separated each with their own SQL , Flds etc. Now, a new startup conditions is provided. The old code dbStartUp=Editpdate is not sufficient to tell whether the startup is normal or grid type.
• Add encrypt option to dbRemoteURL. See API manual.
• Add dbOption="DropFirst=First drop cell text" to distingusih between first selection and no selection. See API manual
• Add to dbOptions = "EditTitle=Small title" above the edit grid.
• Sort functions has been overhaul. InitSort Col now can use names - like "EmployeeID or EmployeeID DESC". See New API manual.
• Get row, col count in GetData changed to integer return instead of string.
• Add GD.Get_title, GD.Get_ASPDBNET, ASPdbNET(Notitle=true) to support control mapping. That means, the entire ASPdbNet output is returned to a string and you can place them in Web Controls. See ASPdbNet in new API manual.
• ASPdbRemote dir offset not work - fixed.
• GridEdit has no JS() support - fixed.
• Filter JS() also working well with Edit and Filter
• Missing property GridStrip = Col | row. Both not working - fixed.
• Form mode status bar recordcount missing - fixed.
• Missing FilterAssistant properties in documentation.
• Filter and Edit Notes does not work when TEXT is not specified - fixed.
• Filter and Edit Notes change to NR class for left justification.
• FilterOnEntry property must be after dbSQL to be effective - fixed. This property is obsolete as user can build their dbSQL any time.
• Re-do InitSortCol (1 based) and add InitSortFlds (0 based). FieldNames are now supported.
• EditAllowZeroLength not effective, always = false - fixed.
• Set dbEmbeddedDSN to same options as dbDSN.
• Add ASPdbPostBack to match the ASPX Postback. See new API manual.
• Change Debug "Fields" type to actual system DbType Member names instead of old ASP style index.
• dbDownloadSQL is incorrect (Deleted) - should use dbDownloadFlds.
• Send Grid to Email format changed - Add Overload ASPdbSednMail(false) to not init the properties.
• CSV/text file DSN not corrrect - fixed.
• Firsttimeonly not working - fixed.
• Make SQL = SQLCLIENT so not to break any old code.
• OracleClient is now working. Add OracleClient type to ADO
• Re-do DataType to use member name only.
• dbEditGridAdd and dbEditGridUpdate defaults to false is not effective - fixed.
• Add, update, gridadd, gridupdate co-exist problem - fixed. See Gridedit example in new API manual.
• New! dbOptions="SingleColumnSort=true" will disable multiple level column sort and simulate the classic single column sort.
• init sort col with [-] will blow up - fixed.
• Sort and initsortcol mixed up with ordinals - fixed.
• Add auto detect SP input Size as input.length.
• GD.Get_RSCOUNT returns 0 at entry - fixed.
• SQLClient seems working with SP with COMPUTE now. MS fixed that?
• InitCol Sort not effective - fixed. Now InitCol sort will also left justify.
• ASPdbNet("New=true") does not work - fixed.
• New! Add ASPdbSP("getall=true") to get all result sets from SP.
• SP always use OLEDB before, now can use SQLCLient.
• SQL and SQLClient mixed up - fixed.
  Dim SP As New Tornado.z
  With SP
    .dbQP = "U=1|S=7|Ps=-1| Ni=none| dt=SQL| Pv=SQLClient| D=fujitsu;pubs;sa;sa| Th=ti=Multiple SP Result Set Demo"
    .dbStoredProc = "spname=reptq2| NORS=false"
    .dbResultSet = 17
    .ASPdbSP("getall=true")
  End With
• Add error trap to SP open.
• Dynalist separate external Trigger Output file cannot retrieve levels, only trigger - fixed.
• Pagesize incorrect in Classic form.
• SQL Select@@ not work correctly - fixed.