Re: [sqlite] SQLite - Upade trigger

Thanks Igor, that's got me going. With regards to the PK, I'm moving from an old MS access database that uses an autonumber field, but has a PK on another unique field and I wanted to keep it the same for ease of conversion, but its not a big deal. bb Igor Tandetnik wrote: > > &qu

[sqlite] SQLite - Upade trigger

Hi I'm new to SQLite and triggers. Is it possible to set a trigger so it updates a field of a new record in a table to the same value as the Autoincrement field. i.e. Field1, Integer Autoincrement Field2, Integer Field3, Text Field4, Text When the user enters text in Field3 & Field4, Field1