mangakissa:
No code is required. Just try the following:
1. Drop a few database related components (SQLite3Connection1, SQLQuery1, SQLTransaction1, DataSource1, DBGrid1) on a forms;
2. Connect the SQLite3Connection1 to a sqlite database, and key in 'Select * from test' into SQLQuery1.SQL ("test" is one of the table in the database);
3.Set the sqlQuery1.Active to True.
4. Now you can see the data in dbgrid1. However you would not able to commit any change in any of the table in the same database from other application (eg. sqlliteStudio). sqlliteStudio will freeze (keep trying to commit the transaction) until I change sqlite3connection1.connected to FALSE