Nomad Sent: Sunday, December 17, 2017 4:11 PM >On Sat Dec 16, 2017 at 07:53:22PM +0000, Nelson, Erik - 2 wrote: >> For unfortunate reasons, I need a query that does an insert and also >> returns at least one row... for example, something along the lines of >> Select 1 as value from (insert into table1 values(a, b, c)) >> I've tried a number of options but haven't been able to get anything ...snip... >> to work. Is it possible?
>How about a user defined function that does the insert in the >background? > SELECT my_insert(table_name, val1, val2); That's a good suggestion- the only input control I have is sql statements that must return at least one row. AFAIK there's no way to make UDFs within that constraint? ---------------------------------------------------------------------- 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