On Tue, May 3, 2011 at 10:29 AM, Rolf Marsh <ro...@pragerphoneapps.com>wrote:
> Good Morning Richard... thanks for the response... after making the
> change you suggested and when doing the build, I get the following error:
>
>
>
>
> l "_sqlite3MisuseError", referenced from:
> -[PointPeekViewController
> imagePickerController:didFinishPickingMediaWithInfo:] in
> PointPeekViewController.o
> ld: symbol(s) not found for architecture armv6
> collect2: ld returned 1 exit status
>
PointPeekViewController is not a part of SQLite, so something else is
seriously wrong here.
>
> 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:
> >
> >> Here is my code, written in Obj-C. I can't figure out what I'm doing
> >> wrong... can someone enlighten me? Please?
> >>
> > Set a breakpoint on sqlite3MisuseError() and see where it is being hit.
> >
> >
> >> NSString * errmsg = nil;
> >> SQLiteDB* db = [SQLiteDB sharedSQLiteDB]; // create the d/b
> >>
> >> NSString *insertCommand = [NSString stringWithFormat:@"INSERT FAIL
> >> INTO CardData (CARD_ID, CARD_NAME, CODE_VAL) VALUES ('/%@', '/%@',
> >> '/%@')", symbol.data, @"Test Card", symbol.typeName];
> >>
> >> sqlite3_exec(db, [insertCommand UTF8String], NULL, NULL,&errmsg);
> >> if(errmsg != NULL)
> >> NSLog(@"insert error: /%@",&errmsg); // DEBUGGING ONLY!
> >>
> >> // now, pull it back out of the d/b and display the data
> >> NSString *sqlStatement = @"SELECT card_id, card_name, code_val FROM
> >> CardData";
> >> sqlite3_stmt *compiledStatement;
> >> int err = sqlite3_prepare_v2(db, [sqlStatement UTF8String], -1,
> >> &compiledStatement, NULL); //<----------- error 21 occurs here
> >> if(err != SQLITE_OK)
> >> NSLog(@"prepare error: /%@", err);
> >> else {
> >> // Loop through the results and add them to the feeds array
> >> while(sqlite3_step(compiledStatement) == SQLITE_ROW) {
> >>
> >> // Read the data from the result row
> >> resultText.text = [NSString stringWithFormat:@"\nDatabase:
> >> \n%@ \n%@ \n%@", resultText.text,
> >> [NSString stringWithUTF8String:(char
> >> *)sqlite3_column_text(compiledStatement, 0)],
> >> [NSString stringWithUTF8String:(char
> >> *)sqlite3_column_text(compiledStatement, 1)],
> >> [NSString stringWithUTF8String:(char
> >> *)sqlite3_column_text(compiledStatement, 2)]];
> >> }
> >> sqlite3_finalize(compiledStatement); // release it...
> >> sqlite3_close(db);
> >> }
> >> _______________________________________________
> >> 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
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
