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以及驱动进行的开发，可惜我拿不到那样的版本，郁闷。看来只能老老实实的找台破电脑。

更新历史

• Fixed:switch system objects and non-sys objects does not hide the system index(Which was introduced in ver0.75).
• Fixed: disable Edit Table for System Table schema and data.
• Updated: Now you can double click on field to view multi-line memo field data.
• New: basic sql autocomplete function.
• New: Add SQL monitor.
• New: Add SQL history.
• Fixed: some quirk focus problem.
• Fixed: does not show explain results.(which was introduced in ver 0.75)
• Updated: executing setting pragma command(pragma name=value) will not show data grid.

下载 这里

最近要把一个其他系统上的程序移植到Windows，其中用到一个数据文件，用原来的程序在Windows上编译后，一运行就访问越界，跟踪后发现，解析文件数据时，凡是读取ULong的地方，数据都取反了，问了一下，原来系统是基于Motorola的CPU的，而motorola CPU同Intel CPU的Word中高低位字节存放顺序正好是反的，因此ULong转换失败，写了一个高低字节转换程序就OK了。这应该是异构系统移植一个常见问题

更新历史

• Fixed:Registered Db was not loaded after starting program(Which was not corrected as expected in ver0.75).
• New: Basic index management (drop , reindex, create, view).
• Updated: Added Data Edit Tab to Edit Table Dialog.
• Update: Add Hints to toolbar button.
• New: Add reindex function to table.
• Fixed: Trigger display order was not correct.
• Fixed: created table display order was not correct.
• Fixed: options dialog always show the data export options even select sql editor option node. (Introduced in ver0.75)
• New: Add View SQL command to View node.
• Fixed:Does not show pragma command execute result(introduced in ver0.75)

  下载地址:这里