databasePath: dbpath: /Users/rolfmarsh/Library/Application Support/iPhone Simulator/5.1/Applications/361A7A76-FEAB-4E67-8F71-C1B291404BA5/Documents/r54.sdb
Regards, Rolf On Jun 3, 2012, at 6:07 AM, Black, Michael (IS) wrote: > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
