Topic: Delete data
Is there a way to delete data of a field or multi fields in a table.
For example A is table and b,c and d are fields of table A and I want to delete all data that stored in field b, c and d of table A.
- unforgettable
- Member
- Offline
- derek
- Moderator
- Offline
Re: Delete data
Try
sqlexecute('update A set B = "", set C = "", set D = ""');
I would recommend taking a copy of the relevant sqlite.db just in case.
Derek.
- unforgettable
- Member
- Offline
Re: Delete data
Thank you derek but syntax error near set display.
- derek
- Moderator
- Offline
Re: Delete data
sorry, it should be
sqlexecute('update A set B = "", C = "", D = ""');
- unforgettable
- Member
- Offline
Re: Delete data
thank you derek. It works now.