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