Re: [sqlite] Undo-Redo

Thomas Flemming wrote: > I'm busy doing a undo-redo with triggers as described here: > https://sqlite.org/undoredo.html > > and wondering, if there is a function to build the string for the > insert-command automatically with all fields from that table. You have to write this function yourself.

Re: [sqlite] Undo-Redo

Dear Tom, There is a pragma that allows you retrieving the structure of a table : PRAGMA table_info(table_name); From the result of the command, you can programmatically create your triggers. Regards, Brice 2017-07-15 21:11 GMT+02:00 Thomas Flemming : > Hi Sqlite-users, > > I'm busy doing a u

[sqlite] Undo-Redo

Hi Sqlite-users, I'm busy doing a undo-redo with triggers as described here: https://sqlite.org/undoredo.html and wondering, if there is a function to build the string for the insert-command automatically with all fields from that table. In the sample its only 3 fields, but in real life, this