All geek questions in one place

There is no such SQLITE_SEQUENCE table from AIR / Actionscript

I am trying to use reset seed for auto increment field in SQLITE using AIR / ActionScript / Flex 4.5.

I am doing what should work fine:

DELETE FROM SQLITE_SEQUENCE WHERE NAME = 'myTable'

I checked that the database actually contains the SQLITE_SEQUENCE table. I can execute the above statement without errors directly through the Firefox SQLITE (SQLite Manager) plugin.

However, when I try to do the same with actionscript, I get an error:

There is no such table "SQLITE_SEQUENCE".

All I could find in the search was that guy who posted wherever he could find - remained unanswered: here as well as here and also here

Any ideas?

+4
source share
1 answer

sqlite_sequence table is not created until you define at least one auto-increment and primary key column in your schema.

+10
source

Source: https://habr.com/ru/post/1369268/

More articles:


All Articles