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:
>
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
2 matches
Mail list logo