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. That page has an example: | Triggers such as the above could be entered manually, but that is | tedious. An important feature of the technique demonstrated below is | that the triggers are generated automatically. | | The implementation language for the example code is TCL, though you can | easily do the same thing in another programming language. Remember that | the code here is a demonstration of the technique, not a drop-in module | that will automatically do everything for you. The demonstration code | shown below is derived from actual code in production use. But you will | need to make changes to tailor it to your application. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users