Simon… what happened to my images and the attachment? I can put them on Dropbox, or do you have somewhere else I can put them so you can access them?
Rolf On Jun 3, 2012, at 7:13 AM, Rolf Marsh wrote: > Simon… please see my responses below… > > Regards, > Rolf > > On Jun 2, 2012, at 6:18 PM, Simon Slavin wrote: > >> >> On 3 Jun 2012, at 12:11am, Rolf Marsh <rmma...@fastmail.us> wrote: >> >>> 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' >> >> In your iPad app, are you using SQLite C functions to call SQLite, or are >> you using s different API ? I was using FMDB; got the error and switched to >> native SQLite3… same results, so it's not FMDB... >> >> Please execute the following in SQL Database Browser and in your iPad app: >> > >> SELECT sqlite_version() > This is from SQLite Database Browser: > > This is from the program > >> >> It's okay that the results from the two pieces of software are different, >> but knowing what they are might help us figure out what's going on. >> >> Please also copy the database to your computer, and use the SQLite shell >> tool to execute the same query. The shell tool is as close to canonical as >> anything is: whatever result that gets is the 'right' result. yes, it got >> the correct result > >> >> Could you possibly reduce your database to just a few records -- just enough >> that it correctly reproduces your problem ? You can use the SQLite shell >> tool to .dump the database which will let you post a complete copy for our >> testing. this d/b is the same one I'm getting the error on… very small... >> >> Simon. >> _______________________________________________ >> 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