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
