Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

Hi Simon… project was cancelled… if it get's resurrected, and I still have the problem, I'll get back to you. Thank you for your time… Regards, Rolf On Jun 4, 2012, at 7:29 AM, Simon Slavin wrote: > > On 4 Jun 2012, at 3:24pm, Rolf Marsh wrote: > >> "Could you possibly

Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

On 4 Jun 2012, at 3:24pm, Rolf Marsh wrote: > "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

Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

Simon… did you get my response to your last question? "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. "

Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

On 4 Jun 2012, at 6:14am, YAN HONG YE wrote: > I have a sqlite db file in my pc, and now I wanna to copy my db file to my > ipad. The format of SQLite databases is identical on every platform. You can make a database on one platform and read it on another. > I need

Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

On Jun 2, 2012, at 6:18 PM, Simon Slavin wrote: > > On 3 Jun 2012, at 12:11am, Rolf Marsh 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). >>

Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

On 3 Jun 2012, at 5:28pm, Rolf Marsh wrote: > 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? Attachments don't work on this list. We don't want everyone sending us

Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

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

Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

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 wrote: > >> I have this select statement which returns the correct results (count = 2) >> when run in SQL Database Browser, but

Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

Hi Tom… by "schema", I'm assuming you are looking for the code to define the tables? If so, here it is; if not, let me know what you are looking for… // create the tables [db executeUpdate:@"CREATE TABLE IF NOT EXISTS CustData (" // one-to-many

Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

___ > 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

Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

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 particula

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

Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

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

Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

On 3 Jun 2012, at 12:11am, Rolf Marsh 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,

Re: [sqlite] Query runs in SQLite Database Browser but not in iPad app

Hi Rolf, There's nothing inherently different about SQLite execution in Objective-C or on iPad. Please post a full (though brief) sample schema, including data, that demonstrates the issue, so we can test. Thanks, Tom Tom Brodhurst-Hill BareFeetWare -- iPhone/iPad/iPod and Mac software