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

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

Not necessarily...you could have another copy with the same tables unless you're creating this thing from scratch every time. If you're opening an exisiting database we've seen a number of people with similar problems who found an "oops" and were opening another copy without data or different

Re: [sqlite] Views Optimization

"Black, Michael (IS)" writes: > Perhaps the query flattener should ignore any nondeterministic functions? > Are there any others besides random() or date/time functions? User defined functions. Or views on virtual tables. -- Steinar

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

databasePath: dbpath: /Users/rolfmarsh/Library/Application Support/iPhone Simulator/5.1/Applications/361A7A76-FEAB-4E67-8F71-C1B291404BA5/Documents/r54.sdb Regards, Rolf On Jun 3, 2012, at 6:07 AM, Black, Michael (IS) wrote: > Not necessarily...you could have another copy with the same

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

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

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

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

[sqlite] error

Hello I have this message everytime i turn my laptop  on "the procedure entry point sqlite3_wal_checkpoint could not be located in the dynamic link library aqlite 3 idllen " can you please help... Thanks Maria Gontan  Aquel que no esta orgulloso de su origen no valdra nunca nada,

Re: [sqlite] error

On 3 Jun 2012, at 6:53pm, Maria Gontan wrote: > I have this message everytime i turn my laptop on "the procedure entry point > sqlite3_wal_checkpoint could not be located in the dynamic link library > aqlite 3 idllen " can you please help... You didn't Google for

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] Views Optimization

Thanks for the answer guys... I'm afraid this is going beyond my SQL knowledge, so I'll let Stephane come back with a better example (when he gets his internet back :p) Guillaume Le vendredi 1 juin 2012 09:30:06 Richard Hipp a écrit : > On Fri, Jun 1, 2012 at 10:33 AM, Guillaume DE BURE < > >

[sqlite] Foreign key constraint failed

Hi all! I have just recently discovered the strengths of foreign keys but now, I've been banging my head against the wall for a couple of days. I just can't figure out what is causing the error or how to get around it. Here's the specs (simplified) of my DB; create table if not exists a (id

Re: [sqlite] Foreign key constraint failed

You are missing parentheses here: create table if not exists a (id integer primary key autoincrement, a text unique, b default current_timestamp); create table if not exists b (id integer primary key autoincrement, a integer references a(id) on update cascade on delete cascade, b text, c text,

[sqlite] Fresh good Cvv+BankLogins+Transfer WU+Dumps+Track+Pin+ Shiping...all countr

Cvv,fullz,banklogins,dumps+pin,track1/2+ pin /paypal/,wu bug/ship iphone4s /Transfer,shop admin, Hotel Reservations,Flight Tickets,Softwares & Spam tools!! Am A Renoun Hacker And Shop Owner...validshop.su HAPPY NEW YEAR CURRENTLY GIVING 1000

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

I have a sqlite db file in my pc, and now I wanna to copy my db file to my ipad. I need open db files in ipad,but I don't know how to open the file. and where should I copy my db files to my ipad. ___ sqlite-users mailing list sqlite-users@sqlite.org