Not necessarily...you could have another copy with the same tables unless you're creating this thing from scratch every time. If you're opening an exisiting database we've seen a number of people with similar problems who found an "oops" and were opening another copy without data or different data.
Are you using an absolute or relative path name? Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Rolf Marsh [rmma...@fastmail.us] Sent: Sunday, June 03, 2012 7:55 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app Hello Michael… yes, there is only one copy of that particular database with that name… if it were a different d/b, it would error out on column names being nonexistent, right? Regards, Rolf (SpokaneDude) On Jun 3, 2012, at 5:34 AM, Black, Michael (IS) wrote: > My first suspiciion would be that you're pointing to 2 different databases. > Are you SURE the DB is the same between the 2 apps? > > > > > > Michael D. Black > > Senior Scientist > > Advanced Analytics Directorate > > Advanced GEOINT Solutions Operating Unit > > Northrop Grumman Information Systems > > ________________________________ > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on > behalf of Rolf Marsh [rmma...@fastmail.us] > Sent: Saturday, June 02, 2012 6:11 PM > To: sqlite-users@sqlite.org > Subject: EXT :[sqlite] Query runs in SQLite Database Browser but not in iPad > app > > I have this select statement which returns the correct results (count = 2) > when run in SQL Database Browser, but not in my Objective-c iPad app (count = > 0). > > select count(orderdata.order_id) from orderdata, custdata, orderinfo > where custdata.customer_id = orderinfo.cust_id and > orderdata.order_id = orderinfo.cust_id and > custdata.Bus_name = 'Albertsons' > > I have also tried it this way using JOINs, but get the same results… > > select count(orderdata.order_id) from orderdata > join custdata on custdata.customer_id = orderinfo.cust_id " > join orderinfo on orderdata.order_id = orderinfo.order_id " > where custdata.Bus_name = 'Albertsons' > > Any ideas why? > _______________________________________________ > 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 _______________________________________________ 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