SQLite and Transaction Management : I wasted 2 hours of my time

SQLite and Transaction Management : I wasted 2 hours of my time

Have you ever interacted with SQlite and wondered why your query is not returning all records in a given table. Well , I have and I almost gave up. It’s such a silly mistake or rather lack of concentration on my part. I wanted to get location data collected at intervals of 1 minute , cache them on SQLite and send them to some server. As simple as that sounds , it turned out to be such a Pain.

This was what was wrong : I was running a query to get all records and within the loop , I was running another Query to get the userID.

Then when I decided to get the userID first and assign it to a variable them use it on the second query which was getting all location records , it worked.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.