Page 1 of 1

How to delete a record in SQLite Database using DataGrid as Table?

Posted: Sat Jan 04, 2020 8:20 am
by shengton
Hello guys,

I'm from the Philippines, very newbie. I try to create a sample app here, just for practicing. I already know how to Save data from the text field to SQLite Database. Now, I'm here at the portion of how to delete a record from the SQLite so that the record that has been deleted will be remove as well in the DataGrid. I don't know how to start the code.

What I want to happen is, I want to put a button inside the DataGrid so that every record has a delete button. My question are:
1. How can I put the button inside the DataGrid?
2. If I put the script in the button using the "DELETE" SQL statement, does it work?

If you have a sample script it would be helpful for me.

Re: How to delete a record in SQLite Database using DataGrid as Table?

Posted: Mon Jan 06, 2020 1:05 pm
by sphere
you can find that info on how to add a button in the DG on lessons.livecode.com