by ivan stimac (8 Submissions)
Category: Databases/Data Access/DAO/ADO
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: (8 Votes)
*****UPDATE: Now read is much faster (before 17 sec for 10000 records, now 0,3 sec)*****
DESCRIPTION:
This is sample of small database engine. It support few SQL queries, add muliple tables, add and DELETE records, username and password for access to databes data... There is also RecordSet class so this make it easiest to use.
Deleted items is only 'invisible' for reading, but they are still in file. So for real remove there is clsDbAdvanced class.
SQL Queries: CREATE TABE, INSERT INTO
For deleting data there is function (supports multiple conditions and operators =, <>, >, <)
For reading there is also function that sets data automaticly to RecordSet.
Please check it and leave feedback and if you wont wote.
Download small Database engine (UPDATE2 speed increased) (30 KB)