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 #34389 is a reply to message #34385]

Sun, 20 November 2011 01:13

lectus
Messages: 329
Registered: September 2006
Location: Brazil

Senior Member

Hi!
I studied the HomeBudget example and put this code together:

	SqlId PHONEBOOK("PHONEBOOK");
	SqlId NAME("name");
	String name = arr.Get(0);
	SQL = db;
	SQL.Begin();
	SQL * Delete(PHONEBOOK).Where(NAME == name);
	SQL.Commit();
	arr.Remove(arr.GetCursor());

And now it works! Very Happy

Looks like I better use this syntax. But I still haven't figured out why it didn't work using Execute().

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: Tue Sep 08 12:43:57 GMT+2 2026

Total time taken to generate the page: 0.01383 seconds