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