On Mon Dec 18, 2017 at 04:48:27PM +0000, Nelson, Erik - 2 wrote: > Nomad Sent: Sunday, December 17, 2017 4:11 PM > >On Sat Dec 16, 2017 at 07:53:22PM +0000, Nelson, Erik - 2 wrote: > > >> 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?
That is quite a constraint. Unfortunately then the UDF option is not available to you. -- Mark Lawrence _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
