Delete Query not working
-
Hi! I'm using SQLite for my game. When a particular button is clicked,I've to get the selection of a list control and delete it from the list control and from the database. for this I'm using the following code and query.
if(m_pSelectProfileImage->getRelativePosition().isPointInside(m_MousePos))
{
stringw strtoDelete = profileList->getListItem(profileList->getSelected());
strtoDelete.make_lower();
strtoDelete.trim();
if(!strtoDelete.equals_ignore_case(L"default"))
{
irr::core::stringc testStr = "DELETE FROM profile WHERE name = '";
testStr += strtoDelete;
testStr += "'";
pManager->SQLdb.Query(testStr);
profileList->removeItem(item);
}
}I execute the above line and open the database file using SQLite Database Browser to check whether the particular record has been deleted. It's not deleted. When I put a break point to verify the query, my list selection is there in the query(testStr). What might be the problem? How to delete a record?
-
Hi! I'm using SQLite for my game. When a particular button is clicked,I've to get the selection of a list control and delete it from the list control and from the database. for this I'm using the following code and query.
if(m_pSelectProfileImage->getRelativePosition().isPointInside(m_MousePos))
{
stringw strtoDelete = profileList->getListItem(profileList->getSelected());
strtoDelete.make_lower();
strtoDelete.trim();
if(!strtoDelete.equals_ignore_case(L"default"))
{
irr::core::stringc testStr = "DELETE FROM profile WHERE name = '";
testStr += strtoDelete;
testStr += "'";
pManager->SQLdb.Query(testStr);
profileList->removeItem(item);
}
}I execute the above line and open the database file using SQLite Database Browser to check whether the particular record has been deleted. It's not deleted. When I put a break point to verify the query, my list selection is there in the query(testStr). What might be the problem? How to delete a record?
Since your SQL query seems to be OK it could be one of two things. It could be that you conversion from strinw to stringc is doing something with the query (eg you are getting strange characters in your query because of conversion issues). A second potential cause could be that the pManager->SQLdb.Query function doesn't actually execute the query but just prepares the internal object for execution (but I can't say this for sure as I have no idea what the buildup of that class is). There is also a note in SQLite that case insensative unicode matching doesn't work see point 18. I hope this helps you a bit along.