[sqlite] [2.8.x] Incrementing a column automatically with INSERT/UPDATE?

[Gilles Ganault]

Hello

	I was wondering if SQLite 2.8.x was able to update a column automatically 
when performing either INSERT or UPDATE, or if this can only be done with 
triggers in 3.x?

For instance, when adding a record, I need to have a counter in the third 
column be incremented by one:

        insert into mytable values (NULL,'bart',counter= counter+1)

Thank you
G.


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------