Annoyance with SQLite3

[cation007]

Hi,
I have a strange problem with sqlite3.

Code:
NSString *queryStatementNS = "drop table \"myTABLE\"";
const char *queryStatement = [queryStatementNS UTF8String];
if(sqlite3_prepare_v2 (db, queryStatement, -1, &dbps, NULL) == SQLITE_OK)
{
if(sqlite3_step (dbps) == SQLITE_OK)
{
}
else
{
NSLog(@"SQL step failed code: %d", sqlite3_step (dbps));
NSLog(@"Attempted Query: %@", queryStatementNS);
}

sqlite3_finalize (dbps);
sqlite3_close(db);
}

Output:
SQL step failed code: 21
Attempted Query: drop table "myTABLE"

I often get this error. Is the syntax wrong ? I checked online which says error 21 means SQLITE_MISUSE.

I thought this error would come up only when we have special characters in the query.

What am I doing wrong ?

Plz help.

Thanks.

[david_david]

NSString *queryStatementNS = "drop table \"myTABLE\"";

use :
NSString *queryStatementNS = "drop table myTABLE";


no need double quotes..

[cation007]

Originally Posted by david_david

use :
NSString *queryStatementNS = "drop table myTABLE";


no need double quotes..

That fives problems with strings with special characters and spaces.

Although, it give me an error code of 21, its still executing. So, I am ignoring the error.

Thanks neways.

[david_david]

the statements like create, drop execute like:

NSString *queryStatementNS = "drop table  myTABLE";

if (sqlite3_exec(database, [queryStatementNS UTF8String], NULL, NULL, NULL) == SQLITE_OK) {
			
			NSLog(@" table deleted");
}else{
			MELog(@"noooo");
}