06/01/2007 ver1.9.0
Improved: Improved: TLzCustomExpression is a pure binary tree, can be visited in Pre-Order,In-Order and Post-Order. You can visit/modify expression(such as where clause, having clause) as easy as visit/modify a binary tree.
Added: Support for CTE in update,delete and insert statement of SQL Server
Improved: Better support for Oracle Data Warehousing related functions
Improved: Better support for top clause in update,delete and insert statement of SQL Server
Fixed: Bug #115,#116,#122,#131,#136,#139.
Download it now.
|
09/19/2006
Improved: Support for DB2.
Improved: And more sql syntax support for MSSQL, Oracle..
Download it now.
|
06/19/2006 ver1.5.0
Improved: Support create function/procedure of MySQL database.
Improved: Support new SQL syntax in Oracle 10g.
Added: Better support to handle expression such flat expression and modify expression.
Added: More demo added to illustrate how to use this parser.
Fixed: Lots of minor bugs fixed.
Download it now.
|
03/24/2006 ver1.2.3
Added: Create trigger of MSSQL is supported now.
Added: Rename command of Oracle is supported now.
Added: ON commit delete/preserve rows clause in create table command of Oracle is supported now.
Added: New property KeepSqlWhenPp is added in TGSqlParser, if this property is set to false, sql objects will be freed after pretty print the SQL immediately, in other words, SQL object will not be available in SqlStatements. Performance will be improved when pretty print the large SQL if KeepSqlWhenPp is set to false. The default value is set to true. This property doesn't effect when you call the parse function, SQL objects will always be saved to the SqlStatements property for further processing
Improved: Pretty print is more faster in .NET version.
Download it now.
|
01/12/2006 ver1.2.3
Performance is improved in all version.
Tab can be configured to ident formatted SQL.
Support of alter view of MSSQL.
Download it now.
|
12/31/2005
General SQL Parser v1.2.0 was released!
Property MsVars renamed to SqlVars in TCustomSqlStatement and all sub classes.Event TOnMsVarEvent changed to TOnSqlVarEvent.
New Oracle SQL dialects supported: Merge, Alter table, Create/alter trigger,rollup and grouping keywords of group clause. Physical property of Create table .
New MSSQL dialects supported: Alter table,Set,Execute command.
Memory leak when parsing MSSQL dialects is fixed.
Memory leak in COM version is fixed,more stable now. Samples of VB script were added.
New property RemoveLinebreakBeforeParse of TFmtOpt was added, to deal with some sqls generated by other tools that insert linebreak into a word.
New property TrimQuotedCharOfEachLine,QuotedCharOfEachLine of TFmtOpt were added, to remove the specified char at the begin/end of each line of input sql.
Download it now.
|
11/13/2005
Add a demo to illustrate how to use General SQL Parser
This demo Rewrite Oracle Propriety Joins to SQL99
Compliant Joins.
Download it now.
|
10/18/2005
General SQL Parser v1.0.0 was released!
Performance of .NET version is great improved.
Download it now.
|
10/03/2005
General SQL Parser v0.9.8 was released!
Introduce new event onTableToken and onFieldToken
Improvement of COM version
try it now.
|
09/05/2005
General SQL Parser v0.9.3 was released!
Rewrite TOnParserTokenEvent,TOnParserTokenErrorEvent,and demo related to these events
Add analytic function support of Oracle SQL dialects.
Hint message reported by parser is more accurate if their are syntax errors
Some minor bugs fixed reported by users.
try it now.
|
08/27/2005
General SQL Parser v0.9.1 was released!
Parser is 50% faster after rebuilding some core classes.
XML output of parse tree for further processing.
User can iterate parse tree, and get all nodes info for your own usage.
Inspect all database objects in sql statements. Currently only support table, field,and function in select,insert,delete,update,create table and drop table statement. Will be support more database object and sql statement soon.
try it now.
|
07/08/2005
General SQL Parser v0.8.1 was released!
Fix some bugs when checking SQL syntax.
for Net version and delphi2005 win32 version are available
try it now.
|
06/29/2005
General SQL Parser v0.8.0 was released!
Pretty print function is great improved,lots of format options added.
for Paramters( :paramname ) support in MSSSQL.
try it now.
|
02/24/2005
General SQL Parser v0.6.8 was released!
Introduces two new classes:TLzJoinItem,TLzJoinItemList
for better support of join table. Add a demo to illustrate
how to use join table related classes: TLzJoin,TLzJoinList,TLzJoinItem,TLzJoinItemList.
try it now.
|
02/09/2005
General SQL Parser v0.6.5 was released!
Better support for join table.
try it now.
|
02/02/2005
General SQL Parser for .NET v0.6 is available now!
Using general sql parser in your .NET application.
try it now.
|
08/23/2004
General SQL Parser v0.3 was released!
It can create different parser type such as geneirc or oracle to deal with different sql dialect,bind and
substitution variable are supported now.
try it now.
|
07/21/2004
General SQL Parser v0.2.1 was released! Introduce some properties and methods in TSelectSqlStatement,TLzTableList and TLzFieldList.try it now.
|
06/24/2004
General SQL Parser v0.2 was released! More than 10 new classes have been introduced,it's
more powerful,try it now.
|
06/21/2004
We have created some polls,you can enter your vote to help us make GSqlParser more useful!
|
06/12/2004
General SQL Parser v0.1 was released! It's free,
and you are welcome to use it and submit your feature request or bug report.
|
