Search found 1 match

Go to advanced search

by yagolnik
22.10.2009, 21:28
Forum: SQLite
Topic: Autoinc primary key not refreshed after post
Replies: 6
Views: 1908

Hi,

You can use in refreshSQL:

SELECT * FROM mytable
WHERE
( (:OLD_ID is not null) AND (ID = :OLD_ID))
OR
( (:OLD_ID is null) AND (RowID = (select max(rowid) from mytable)) )


Alex

Go to advanced search