SQL database engine and interface to it in a single ActiveX. Single file holds the entire database, same db file format on all the platforms, national characters are preserved. Support for OLE date/time values, self-dependent and zero-configuration.
This member of the AXPack1 Family depends only on the AXPack1 core DLL. It uses some VarDictionary collections from it which makes the data extracted from the DB easy to convert, clone and manage. SQLite COM is packed into the AXPack1 Family distributions and the applications may benefit of the combined strangth of the entire library.
While the component is based on the popular SQLite public domain source code it adds some features useful for Windows programming - such as OLE DATE type internal support functions, automatic type conversion of the internal data to directly usable VARIANT types.
Good SQL support. Supports triggers, indices, views, complex queries and joins. The component is fully independent of ADO, OLEDB, ODBC and so on. The DB interface is custom, but convenient and easy to learn. It resembles features from ADO's GetRows and recordsets in a fashion that needs times less code than the traditional recordset based DB interfacces.
Combined use with Sprintf/Sprintf/SAprintf from StringUtilities object (part of the AXPAck1 core - always available with SQLite COM) makes the SQL statements generation easy and powerful.
Autorun compatible - i.e. automation support is available without need to register the component with the system first. Especially useful in Active Local Pages based autoruns.
Platform: Win95,Win98,WinME,WinXP,Windows2000,Windows2003,Windows CE,Pocket PC
Link to SQLite COM sample code
Date Added: Oct 30, 2006
Last check for an update: Oct 26, 2016
Last version date: Feb 15, 2005
Downloads Total : 5
Downloads last 10 Days: None
Page Visit: 161
Malware Status: Clean
Scan Date: Apr 08, 2008