> 4. Try to select against any of these tables and 0 results are returned > yet, the client db hasn't actually changed it's size.
By default SQLite doesn't shrink database file size when deleting data, although it reuses this space later when you insert new data. If you want to shrink file size you need to use VACUUM or PRAGMA auto_vacuum. > 5. When debugging the issue, the app still reports all entries via SQL > query that I, thought were deleted from within SqlShell. Did you issue COMMIT in your SqlShell? If you close database in SqlShell and then reopen again will it still report no rows in the database? > When I place a debug Message box to display the messages selected from the > client db I see all the messages even though a select statement against the > tables returns 0 results. I wonder what did you mean to say here. If SELECT statement returns 0 rows you can't show any messages unless you get it from somewhere else. > I know I am accessing the same database, because if I copy a completely empty > database, to where the client db is. Then the app reports 0 records. And after doing that if you insert some rows from SqlShell will the app report any records? If not or if database reopening in SqlShell (which was suggested above) still results in different number of records in app and in SqlShell then you definitely use different database files. Pavel On Tue, Jun 19, 2012 at 11:09 AM, <chris_how...@mcafee.com> wrote: > I've got a bit of an interesting issue that I am hoping to get some help on. > The issue goes a little bit like this. > > Using Windows 8 64bit, Release Preview 8400. (Classic Mode) > > 1. Our product is installed and requests data from the server. (Server > responds and populates a database on the client machine). > 2. Connect to the database on the client machine (Open the database > using SQLShell) can see the entries in the database, so I know the database > is being populated. > 3. Execute delete statements, on tables in SQLLIte Database. > 4. Try to select against any of these tables and 0 results are returned > yet, the client db hasn't actually changed it's size. > 5. When debugging the issue, the app still reports all entries via SQL > query that I, thought were deleted from within SqlShell. > > Essentially it's as if the messages are being flagged for deletion but not > actually getting deleted. When I place a debug Message box to display the > messages selected from the client db I see all the messages even though a > select statement against the tables returns 0 results. > > I know I am accessing the same database, because if I copy a completely empty > database, to where the client db is. Then the app reports 0 records. > > Any light someone could shed on this would be appreciated. > > Cheers, > Chris > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
