On Tue, May 3, 2011 at 9:46 AM, Rolf Marsh <[email protected]>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
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
