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 ? Please execute the following in SQL Database Browser and in your iPad app: SELECT sqlite_version() 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. 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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
