[sqlite] Question on database locking or corrupted
I am currently using Sqlite version 2.8.13. We have one thread that constantly inserts data to sqlite tables. I have a UI application that reads data from the same database, I sometimes get an error from the UI app: "Attempted to read or write protected memory. This is often indication that other memory is corrupt." When I try to do select from the sqlite command prompt, I got the SQL error: database is locked. Please advice on what I can do to eliminate the read lock access problem. Thank you for your help. Trien ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] FW: Question on delete record in a master-detail type tables
> -Original Message- > From: Dao, Trien (STP) > Sent: Friday, January 16, 2009 10:32 AM > To: 'sqlite-users-boun...@sqlite.org' > Subject: Question on delete record in a master-detail type tables > > I have two tables - header and detail tables - that are a master -detail type > setup, with header ID item is the FK to rowID in the detail table. Deleting > a record in the header table, would that also delete the records in the > detail table? Please recommend the best way to delete both the master and > detail records. Thank you for your help. > > Trien ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Creating sqlite.dll and sqliteclient.dll for .net with sqlite version 3-3.6.7
I am new to sqlite development community. I need to create or obtain sqlite.dll and sqliteclient.dll for sqlite version 3-3.6.7. My questions are: 1) Where do I find the new versions of sqlite.dll and sqliteclient.dll 2) or where do I get the .NET version source code and where do I find instruction for creating .dll files. We are currently using sqlite version 2.8.13. However I have a .NET application that is a multi threads application, with each thread can insert a data row to a sqlite database. I receive an error from one the the thread that tries to insert data {"Attempted to read or write protected memory. This is often an indication that other memory is corrupt."} My hope is that the new sqlite version can resolve this problem. Any suggestion would be greatly appreciated. Trien ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users