Re: [sqlite] Locking in 3.0.6

2004-09-10 Thread D. Richard Hipp
Steve O'Hara wrote: The audit logic is as follows; begin transaction select total from useractivity where event= . If lRows = 0 Then insert into useractivity .. Else update useractivity . End If commit transaction Is useractivity.event UNIQUE? Does it us

RE: [sqlite] Locking in 3.0.6

2004-09-08 Thread Steve O'Hara
Hi Richard, I haven't had any response from anyone else so I thought I'd try you direct Richard. I'm wondering what logic I should employ to prevent mutual exclusion occurring. I'm using SQLite to record an audit trail from a web application - I count the number of edits, searches and the maximu