I have a table with 9 records. When I run 'SELECT * FROM table;' in my VB.Net I only get 6 from the 9 records. When I run the query in 'DB Browser' an SQLite viewer I get them all.
The thing is there is a service running in the background who adds records to the database (POS system) I can't stop this service and all the new records that are added I can't see in my query result. It's like the database is locked for other users and so it gives an old snapshot of the database... Very Strange. How can I prevent this? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users