[sqlite] Getting an error 21 when doing a sqlite3_prepare_v2

2011-05-03 Thread Rolf Marsh
Here is my code, written in Obj-C. I can't figure out what I'm doing wrong... can someone enlighten me? Please? NSString * errmsg = nil; SQLiteDB* db = [SQLiteDB sharedSQLiteDB]; // create the d/b NSString *insertCommand = [NSString stringWithFormat:@"INSERT FAIL INTO

Re: [sqlite] ADV: "Using SQLite" ebook, 50% off today

2011-05-03 Thread Rolf Marsh
I bought the hard copy several months ago... I use it all the time... On 5/3/11 9:20 AM, Simon Slavin wrote: > O'Reilly > >Media ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Need help understanding how to post to this list

2011-05-03 Thread Rolf Marsh
Hello.. I just joined today and can't seem to figure out how to start a new thread... Can someone please enlighten me? Regards, Rolf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How do I make a "singleton" using FMDB?

2011-05-03 Thread Rolf Marsh
I'm having a hard time changing my Obj-C SQLite3 code to FMDB... the code works (after a fashion), but I need it to be a singleton (my current SQLite3 code is currently a singleton)... my problem is I don't know what has to be changed from my existing code, since FMDB has it's own

Re: [sqlite] Getting an error 21 when doing a sqlite3_prepare_v2

2011-05-04 Thread Rolf Marsh
iaWithInfo:] in PointPeekViewController.o ld: symbol(s) not found for architecture armv6 collect2: ld returned 1 exit status This is an iPhone app, using XCode 4 for the build... Regards, Rolf On 5/3/11 6:52 AM, Richard Hipp wrote: > On Tue, May 3, 2011 at 9:46 AM, Rolf Marsh<ro...@pragerphoneapps.com>wrote: &

Re: [sqlite] How do I make a "singleton" using FMDB?

2011-05-04 Thread Rolf Marsh
I think I figured it out on my own (a good night's sleep helps!)... thanks everybody... R On 5/3/11 4:14 PM, Rolf Marsh wrote: > I'm having a hard time changing my Obj-C SQLite3 code to FMDB... the > code works (after a fashion), but I need it to be a singleton (my > current SQL

[sqlite] Out of memory? How could that be on a 32G iPhone?

2011-05-04 Thread Rolf Marsh
Prior to getting this error, I opened the d/b and inserted one (1) very small record... Where do I start looking? I am using FMDB, ZBarSDK (used to read barcodes), but I can't imagine that's using all of my memory... and I have the d/b set to be a singleton, as indicated by the NSLog

Re: [sqlite] Out of memory? How could that be on a 32G iPhone?

2011-05-04 Thread Rolf Marsh
> Hi Rolf, > > I am using FMDB and SQLite for more than 2 years now and have not experienced > any problems so far. Therefore, I expect that the bug is somewhere else but > not inside SQLite (3.7.2) nor FMDB (2009-10-18). > > Greetings, > Hartwig > > Am 04.05.2011 um

Re: [sqlite] Out of memory? How could that be on a 32G iPhone?

2011-05-06 Thread Rolf Marsh
I figured this out... it was a "pilot-error" on my part...but I do have an additional question (see below). On 5/5/11 9:45 AM, Jean-Denis Muys wrote: > On 4 mai 2011, at 23:22, Rolf Marsh wrote: > > > > Prior to getting this error, I opened the d/b and inserted on

Re: [sqlite] Out of memory? How could that be on a 32G iPhone?

2011-05-06 Thread Rolf Marsh
Thank you for the clarification... I appreciate it... Regards, Rolf On 5/6/11 6:23 AM, Jean-Denis Muys wrote: > On 6 mai 2011, at 15:09, Rolf Marsh wrote: > > I figured this out... it was a "pilot-error" on my part...but I do have > an additional question (see below). >

[sqlite] How to get returned errors programmatically from SQLite

2011-05-06 Thread Rolf Marsh
I apologize if this is not the correct place to ask this question. I am using FMDB; I have an INSERT statement that is failing on a "constraint error" (duplicate record which is the correct error). My question is: how do I determine programmatically (using Obj-C) what, if any, error was

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

2012-06-02 Thread Rolf Marsh
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

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

2012-06-03 Thread Rolf Marsh
> > Northrop Grumman Information Systems > > > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on > behalf of Rolf Marsh [rmma...@fastmail.us] > Sent: Saturday, June 02, 2012 6:11 PM > To: sqlite-users@sqlite.org > Subject: EXT :

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

2012-06-03 Thread Rolf Marsh
___ > 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

2012-06-03 Thread Rolf Marsh
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

2012-06-03 Thread Rolf Marsh
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

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

2012-06-03 Thread Rolf Marsh
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

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

2012-06-03 Thread Rolf Marsh
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 Objectiv

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

2012-06-04 Thread Rolf Marsh
sting. " 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 On Jun 3, 2012, at 10:40 AM, Simon Slavin wrote: > > On 3 Jun 2012, at 5:28pm, Rolf Marsh <rmma...@fastmail.us> wr

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

2012-06-04 Thread Rolf Marsh
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 <rmma...@fastmail.us> wrote: > >>