Re: [sqlite] ALTER TABLE fails when there is an INSTEAD-OF trigger of a VIEW

Am Do., 27. Dez. 2018 um 02:53 Uhr schrieb Mark Johnson < mj10...@googlemail.com>: > (summery of the last messages that were sent as email) > > >> Please add the list of column names after the view name: > >> CREATE VIEW middle_earth_admin_general(a,b,c,e) AS ...

Re: [sqlite] ALTER TABLE fails when there is an INSTEAD-OF trigger of a VIEW

(summery of the last messages that were sent as email) >> Please add the list of column names after the view name: >> CREATE VIEW middle_earth_admin_general(a,b,c,e) AS ... >> I have a note to improve the documentation about this point. So would the following be true: To insure that a constant,

Re: [sqlite] ALTER TABLE fails when there is an INSTEAD-OF trigger of a VIEW

Am Do., 20. Dez. 2018 um 16:34 Uhr schrieb Mark Johnson < mj10...@googlemail.com>: > Based on ticket > > https://www.sqlite.org/src/tktview?name=43ddc85a63 > > > > However, the column count is not correct. > In my case 2 columns are missing: which should be 19. >

[sqlite] ALTER TABLE fails when there is an INSTEAD-OF trigger of a VIEW

l->zName[id_belongs_to]==zCol[text] -I-> lookupName -202a loop - iCol[16] pCol->zName[id_belongs_to]==zCol[eur_point] resulting in the error: error in trigger vw_ins_middle_earth_general: no such column: NEW.id_belongs_to. Mark Johnson mj10...@googlemail.com ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users