Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Sqlite Delete not working [SOLVED]
Re: Sqlite Delete not working [message #34391 is a reply to message #34390] Sun, 20 November 2011 02:07 Go to previous messageGo to previous message
lectus is currently offline  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.

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Error when compiling native MySql with MSC9
Next Topic: sql + editstring
Goto Forum:
  


Current Time: Tue May 07 23:49:21 CEST 2024

Total time taken to generate the page: 0.02091 seconds