1.02.75 Alpha2 (11/07/2005)

• Fixed:Can not load ParserDll.dll on windows 2000 system.

1.02 Alpha2 (11/06/2005)

• Fixed:[DBA] when edit table , grid shows xxx(1,2) datatype as xxx uncorrectly
• Fixed:[Parser] can not parse create table sql with varchar, char, nchar, double ,numeric etc field type columns
• New: [Export/Import] Import data from CSV when edit table data
• Updated: [DBA] when pk's is autoincrement, automaticlly set Data Type to integer
• Updated: [DBA] show Db Explorer's Db or table information at status bar
• Updated:[GUI] Add Rows Affected Information to Log
• New: [SQL Editor] Add Save SQL and Load SQL function to SQL Editor
• Updated: [DBA] After Creating Table, automaticlly refresh Indexes
• Updated:[SQL Editor] now Log was displayed order by date desc
• New: [GUI] Add Windows Menu
• New: [Install] Add a sample sqlite3 db (Sample.db3) to install package
• New: [DBA] Add basic clipborad operation to Data Grid
• New: [Option] Add SQL Editor Font Option to configure the Font and Font size.

我用过最可怕的Unix类的操作系统是DEC的VMS操作系统，上面的命令给我感觉好像是咒语一样，每次敲的时候都要把参考手册翻出来，每次敲完命令都感觉恶心的要吐。

我用过的最可怕的编程语言是VB，因为没有真正的异常处理，所以你永远不会知道用VB写的程序为什么会突然当掉

昨天陈春华朋友给我写信，说他下载了我的Sqlite Developer，结果安装后无法运行，报无法加载ParserDLL.dll错误，我当时觉得很奇怪，因为我测试了一下在我的开发机器XP上没有问题，经询问才知道他的操作系统是Windows2000。今天我在Windows2000上重现了这个错误，仔细Review了一下代码，发现显式引用DLL的地方是这样写的。

const
//Fix can not load ParserDll.dll on windows 2000 system
ParserDll='ParserDll';

其中DLL扩展名没有写，这样的调用在XP系统上是正确的，但是在Windows2000系统上就会失败。

0.97 Alpha1 (10/30/2005)

• Fixed:[DBA] adjust too large string field display length in Data Grid
• Fixed:[DBA] disable edit system table
• Fixed: [DBA] make Data type names showed in Table Edit Grid same as the sqlite standard
• New: [SQL Editor] Support view and edit string , blob field as Hex Value
• New: [DBA] Advanced Index Management
• New: [DBA] Add Old DDL Tab to Table, Trigger, Index and View Management UI.
• Updated:[DBA] drop table, view and refresh the indexes and triggers at the same time
• Updated: [Parser] when rollback automatically refresh the Db Explorer
• Fixed: [SQL Editor] minor tweak DataType display in the auto complete window
• Fixed:[DBA] now we can generate correct multi primary key create table sql
• Fixed: [Query Builder] Query Builder now supports Views
• Fixed: [DBA] Completely rewrite the Table Management and fixed lots of bugs.
• Updated: [Install] Upgrade LiveUpdate

这两天我在CSDN上的网站空间域名解析有问题，所以我决定将原来的Delphi深度探索网站转移出来，今后大家可以用二级域名http://delphi.sharpplus.com进行访问

更新历史

• Fixed:[Parser] some create SQL will not automaticlly add node to DB Explorer when executed successfully
• Updated:Upgrade sqlite dll to 3.27.
• Fixed: [Parser] Can not parse 'XXX' and "YYY" type table name
• New: [DBA] support display and edit the temp table, view,trigger
• New: [GUI] Add two new filter(All non-system and non-temporary Objects, All non-temporary Objects)
• Updated:[GUI] display sqlite3 DLL version in About Dialog
• Updated: [GUI] Show different icons with tempoary and system table, view, trigger, index.
• Updated: [GUI] Add some icon to menuitem
• Updated: [GUI] Minor tweak of options menu
• Fixed:[DBA] Execute sql does not hide the result tab
• New: [DBA] Advanced Trigger Management
• New: [DBA] Add advanced view management

不能在Parser部分对Rule使用~操作符号

对于Parser Rule,只能使用+, *, ?

但是可以对Lexer Rule使用~操作符号

出于性能的考虑，Antlr没有实现完全的LL（K）解析，而是用了线性的LL（K），但是线性LLK会产生很多的不确定性。经常导致你需要将自然的Parser Rule改写为不自然的形式。

不过据说Antlr 3将提供完全的LL（K）实现，不过从目前的进度来看，感觉要到2007年能推出就不错了:(

更新历史:

• Updated:Now we can switch opened database in query form.
• Updated:Upgrade sqlite dll to 3.26.
• New: Added Log Tab to Query Form
• Updated: after executing create and drop table, view, trigger, index sql , db explorer will automatically be refreshed.
• New: Basic db schema extract function.
• New: View and Edit Blob Field.
• New: implement Database MainMenu.
• Fixed: Do not invoke autocomplete in comment block.
• Fixed: when clear sql monitor sql edit was not cleared.
• Fixed: now sql parser can correctly process sql which contains mulit-line comment.
• Fixed: DB Explorer will show plus sign before node even child node count=0.
• New: Add Explain Query Plan Function.

下载:这里

因为VxSim模拟器支持的VxWorks功能有限，因此想装一个真正的VxWorks的运行环境，最开始想到的是在vmware上装一个，这样可以比较省事，但是花了一下午的时间，在MS—DOS虚机上装出来的VxWorks一启动就崩溃了，总是不行，后来在Google上查了一下，才发现Vmware不支持VxWorks，据说Wind River开发组的人内部是用修改过的Vmware和特殊的BSP以及驱动进行的开发，可惜我拿不到那样的版本，郁闷。看来只能老老实实的找台破电脑。