Sqlite multiple statement with semi colon not working from iOS app

[jigneshchovatiya]

I have to update multiple statement in sqlite database from my iOs app. for that I have written following string.

query = @"UPDATE channels set sts = 'A' , isowner = '1' WHERE channelid=6798;
UPDATE channels set sts = 'A' , isowner = '1', srl = '175' WHERE channelid=6795;";
NSLog(@"query %@",query);
[dbManager executeQuery:query];

I have create a string/statment as string with semi colon. It is worked perfectly in sqlite browser/editor, but not working in iOS app. It not throwing any error while executing statement. I don't find any mistake in my code. (as per my best knowledge). Can someone help me, why it is not working?

It is very urgent for me.

Thanks.

[bluetechy]

I believe by default the sqlite3 library prevents this for security reasons because it exposes an SQL insertion attack. Here are a few possible solutions:

1. Separate the UPDATE statements and run them separately (probably best within a transaction).
2. Edit https://github.com/ziminji/objective-c-sql-query-builder/blob/ARC/master/src/db/ZIMDbConnection.m#L146-L193 by un-commentting the commentted lines and comment out the sqlite3_exec command.