Home » U++ Library support » U++ SQL » Sqlite Delete not working [SOLVED]
| Sqlite Delete not working [SOLVED] [message #34385] |
Sat, 19 November 2011 23:10  |
lectus
Messages: 329
Registered: September 2006
Location: Brazil
|
Senior Member |
|
|
Hello!
I'm trying Upp with Sqlite and an ArrayCtrl. So far this is an excellent tool for my tiny database apps. I got all the CRUD operations to work, but DELETE is not working.
Here is the code for DELETE:
String name = arr.Get(0);
Sql sql(db);
String x = "DELETE FROM PHONEBOOK WHERE NAME = '";
x += name;
x += "');";
sql.Execute(x);
arr.Remove(arr.GetCursor());
After this code gets executed the record is removed from ArrayCtrl arr, but the database doesn't change. When I refresh it the record is still there.
Any ideas?
Thanks
[Updated on: Sun, 20 November 2011 02:08] Report message to a moderator |
|
|
|
Current Time: Fri Apr 26 17:40:36 CEST 2024
Total time taken to generate the page: 0.03247 seconds
|
Members
Pages
Help
Register
Login
Home
