Kees Nuyt Sent: Monday, December 18, 2017 12:51 PM On Sat, 16 Dec 2017 21:43:44 +0000, "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. I want to cause some rows to be >> inserted into a table but plain insert queries >> don't work because they violate the application's >> assumption that a result will be returned. >Something like: https://sqlite.org/pragma.html#pragma_count_changes (deprecated, but might still work) Great suggestion! The classical form of the pragma doesn't return any columns, and I don't think this pragma is available in the pragma functions (and wouldn't help much anyway, the app is built with sqlite 3.13.0) These are all good suggestions, thanks to everyone who has responded! ---------------------------------------------------------------------- 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
