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