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 #34389 is a reply to message #34385] Sun, 20 November 2011 01:13 Go to previous messageGo to previous message
lectus is currently offline  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().
 
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 19:21:52 CEST 2024

Total time taken to generate the page: 0.02879 seconds