lectus Messages: 329 Registered: September 2006 Location: Brazil
Senior Member
Sender Ghost wrote on Sat, 19 November 2011 19:33
lectus wrote on Sun, 20 November 2011 01:13
But I still haven't figured out why it didn't work using Execute().
Hello.
Because of quotes for name and ")" at the end?
Look here for the raw delete examples.
Yeah true. The syntax of the DELETE command was wrong. lol
There was an extra ")" at the end. And the ' are required.
Now it worked.
The correct concatenation of the string is:
String x = "DELETE FROM PHONEBOOK WHERE NAME = '";
x += nome;
x += "';";
Even though the examples you provided are in Tcl language. In this language "name" and name are the same since everything is a string in Tcl.