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 (shows 3.6.1.8) and in > your iPad app: 3.7.7 Shell tool: 3.7.7 > > 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. shell tool > gives the correct value: 2 > > 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. Sorry, but I don't know how to do this… can you give me the syntax? > and where will the output go? and do you want me to put the output on > PasteBin?
Rolf > > 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
