Good morning,
Is there a quick way to reset all values of a column in a Sqlite table?
Thank you for your help
Sqlite and column reset
Re: Sqlite and column reset
Hello Kiffi,
Thank you for your answer.
So I don't need to do a select * and read each record to do update?
Thank you for your answer.
So I don't need to do a select * and read each record to do update?
Re: Sqlite and column reset
You can run the update-statement directly on the database with DatabaseUpdate(). The missing "Where"-clause causes all values of the column to be changed in one step.
Hygge
Re: Sqlite and column reset
OK thank you