sqlite的COM-wrapper

Update of dhSQLite to Version 1.1. (now coming with sqlite_engine.dll 3.3.17) Just finished a fast Command-Object-Implementation, mainly to speed up your Inserts, but also useful for somewhat "stronger typing". E.g. on a "8-mixed-columns"-table you can perform now ca. 100000 Inserts/sec using this thin wrapper around the sqlite_bind*-calls. Also added a ShortDate-Type and a Time-Type to the already existent Auto-Date-Type (wich only supported the "long Dates", respective the "Date+Time"-Types). Major UpdateBatch-Performance-Improvements. Before starting this project on your Developer-machine, make sure you have registered dhSQLite.dll on your system (please deregister an eventually older dhSQLite-Version 1.0 first). In addition to the registration you have to place a copy of the "non-activex-dll": sqlite3_engine.dll either in your VB6.exe-Path (because this is your Host-Process, if you develop or run COMponents in the VB-IDE) - or you can also place the engine-dll inside your \system32-folder. Again, this is not needed, if you want to deploy your solution. Then the Host-Process is your own Application.exe of course - in this case you can place the two Dlls beside this Binary. If you want to have XCopy-deployment for your solution (means, if you want to avoid the registering of the AX-Dll dhSQLite, then you can use our free DirectCOM.Dll, to instantiate Classes from dhSQLite.dll directly from the FileSystem. More Infos come inside the Form-Modules of the Demo. The Demo-Code is commented and should give you a good start, how to work with the dhSQLite-Wrapper. This Demo has additional dependencies, because it uses the VB6-Datagrid- Control to visualize Recordset-Content - just let me know, if that is a "show-stopper" for you (e.g. if your developer machine doesn't contain this component). Feel free, to send me an email, if you have questions regarding the examples ([email protected]). Hope you enjoy - and of course thanks to D. Richard Hipp and the SQLite-community for this great DB-engine, wich is truly "reduced to the max". :-) If you want to stay up to date regarding my free COM-Tools - e.g. stresstest our just updated RPCServer-environment (now with an integrated dhSQLite-MultiUser-Demo), please visit www.TheCommon.net, wich is now online again. Olaf Schmidt, April 2007