Android Question TRUNCATE TABLE + crash app

S

sorex

Expert

Licensed User

Longtime User

• Feb 3, 2016

• #2

try

B4X:

Main.SQL.ExecNonQuery("delete from wyniki")

 

Upvote 0

S

sorex

Expert

Licensed User

Longtime User

• Feb 3, 2016

• #3

just did a search for truncate but it doesn't seem to be a supported keyword for SQLite.

 

Upvote 0

MichalK73

Well-Known Member

Licensed User

Longtime User

• Feb 3, 2016

• #4

sorex said:

try

B4X:

Main.SQL.ExecNonQuery("delete from wyniki")

Click to expand...

Many thanks to 'delete from table' clears the entire array as it should be.
I have not seen that sqllite not support TRUNCATE.

 

Upvote 0

S

sorex

Expert

Licensed User

Longtime User

• Feb 3, 2016

• #5

does it clear the ID count aswell?

that's the different with other databases. delete trashes but the ID count remains while truncate resets the ID count back to 0.

 

Upvote 0

MichalK73

Well-Known Member

Licensed User

Longtime User

• Feb 3, 2016

• #6

OK

 

Upvote 0

Lahksman

Active Member

Licensed User

Longtime User

• Feb 3, 2016

• #7

If you are using autoincrement, this is stored in the sqllite_sequence table (part of the sqlite_master). It uses 2 column [name] and [seq] and can be altered by the usual UPDATE, INSERT and DELETE statements.
Making modifications to this table will likely perturb the AUTOINCREMENT key generation algorithm. Make sure you know what you are doing before you undertake such changes.

 

Upvote 0