With row producing I mean you will get return values, so mainly select statements, but also certain pragma's and for example the explain statement. In my thinking I would classify INSERT INTO table1 VALUES(1) as non row producing.
RBS On Sat, Jan 9, 2016 at 9:45 AM, Luuk <luuk34 at gmail.com> wrote: > > > On 08-01-16 21:27, Bart Smissaert wrote: > >> I am interested to know from the statement string if the statement is >> invalid, row producing (could produce rows) or non row producing. I know >> sqlite3_prepare16_v2 can see if the statement is valid or not but how >> about >> the other 2? >> I can do this in code no problem, but it may not always be 100% reliable >> for example there >> could be a new pragma or maybe some new SQL keyword. >> >> >> > > What is you exact definition of 'row_producing' and 'non_row_producing'? > > Will this statement be 'row_producing' or 'no_row_producing' or ...?: > INSERT INTO table1 VALUES(1); > if table1 is defined as 'CREATE TABLE table1(i INTEGER PRIMARY KEY);' > > how does this change if the table was defined as: > CREATE TABLE table1(i); > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
