U++ framework: U++ SQL » Sqlite Delete not working [SOLVED]

Home » U++ Library support » U++ SQL » Sqlite Delete not working [SOLVED]

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Sqlite Delete not working [message #34391 is a reply to message #34390]

Sun, 20 November 2011 02:07

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.

Report message to a moderator

[Message index]

		Sqlite Delete not working [SOLVED] By: lectus on Sat, 19 November 2011 23:10
		Re: Sqlite Delete not working By: lectus on Sat, 19 November 2011 23:48
		Re: Sqlite Delete not working By: tojocky on Sun, 20 November 2011 00:15
		Re: Sqlite Delete not working By: lectus on Sun, 20 November 2011 00:20
		Re: Sqlite Delete not working By: lectus on Sun, 20 November 2011 01:13
		Re: Sqlite Delete not working By: Sender Ghost on Sun, 20 November 2011 01:33
		Re: Sqlite Delete not working By: lectus on Sun, 20 November 2011 02:07
		Re: Sqlite Delete not working By: Sender Ghost on Sun, 20 November 2011 05:36
		Re: Sqlite Delete not working By: mirek on Sun, 20 November 2011 09:13
		Re: Sqlite Delete not working By: Sender Ghost on Sun, 20 November 2011 09:59
		Re: Sqlite Delete not working [SOLVED] By: lectus on Sun, 20 November 2011 16:21

Previous Topic:	Error when compiling native MySql with MSC9
Next Topic:	sql + editstring

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Sep 18 12:22:52 GMT+2 2026

Total time taken to generate the page: 0.03090 seconds