[sqlite] : it seems to be only orber by and group

but I fail to get it done. Hello, I got the following problem, that I cannot get worked out. I have a table that has 3 columns A, B and C. C is a boolean Column, that indicates if the record has been logically deleted, It shall not be removed from the database. The table shall be ordered

[sqlite] : Vacuum and WiCe (Windows Embbeded Compact 7)

Hello, I am developing an application for Windows Compact Embedded 7 using .net 3.5 and sqlite. Is there a possibility to run vacuum, mean to compact the database und WinCe from a C# Program? Thank you very much.

[sqlite] Copy data between to databases unsing windows embedded compact 7, .net 3.5

Hi, I am developing an application for Windows Compact Embedded 7 using .net 3.5 and sqlite. We have two databases, db1, db2. A table shall b e copied from db1 to db2 using .net and c#. INSERT INTO db1.table SELECT * FROM db2.table How can I execute this command using ado.net 3.5 (Ce.net

[sqlite] Database corrupted after OS Out of memory exception

Hello, we are developing an application Using SQLite3 on Windows embedded compact 7 using C# 3.5. We have had no problems with corrupted databases so far, even though I always kill the running process in the debugger. The development process is now 2 Years. Also, some months ago we had a lot