Simon Slavin wrote on Saturday, December 16, 2017 5:15 PM >>On 16 Dec 2017, at 9:43pm, Nelson, Erik - 2 <erik.l.nel...@bankofamerica.com> >>wrote:
>> I'm using an application that I can't change. I can give it multiple >> queries to run but the application assumes that each query will produce at >> least one row and causes an error if that's not the case. >Will the application recognise two statements separated by a semicolon ? This >happens automatically if it is using sqlite3_exec(). If it does, then you can >do >INSERT into table1 values(1, 2, 3); SELECT 1 >As if it’s a single statement and it’ll return the result of SELECT 1 This might work- I've never tried passing two statements in as a single 'query' but afaik the semicolon doesn't have any particular significance to the application. I believe the application is using the prepare()/step() interface but it's worth a try. Thanks for the suggestion! ---------------------------------------------------------------------- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
