You are right, Igor. Clear case of XY problem. I will remove trigger.
Roman Sent from my T-Mobile 4G LTE Device -------- Original message -------- From: Igor Tandetnik <i...@tandetnik.org> Date: 1/26/18 9:03 PM (GMT-05:00) To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] primary key in another column On 1/26/2018 6:20 PM, Roman Fleysher wrote: > I think I effectively did as you suggested using triggers. I insert NULL into > the ID column to create a row. This triggers the trigger to run update on the > table to populate the columns based on the just created ID. Is this what you > suggested? Roughly, though running a single statement at the end seems simpler, and likely goes faster, than setting up a trigger. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
