Styjun

How in the world do I place line of text EVENLY between two horizontal tikz lines?

Dangerous workplace travelling

Can there be a single technologically advanced nation, in a continent full of non-technologically advanced nations?

Why is my arithmetic with a long long int behaving this way?

Out of scope work duties and resignation

Why would a military not separate its forces into different branches?

Feasibility of lava beings?

What was the first story to feature the plot "the monsters were human all along"?

Can my 2 children, aged 10 and 12, who are US citizens, travel to the USA on expired American passports?

Is any special diet an effective treatment of autism?

SOQL query WHERE filter by specific months

Why is "breaking the mould" positively connoted?

Is 'contemporary' ambiguous and if so is there a better word?

Handling Null values (and equivalents) routinely in Python

Will 700 more planes a day fly because of the Heathrow expansion?

It is as simple as ABC

What was Bran's plan to kill the Night King?

How do I calculate how many of an item I'll have in this inventory system?

Javascript - Run my script only if landscape is detected

How to pass hash as password to ssh server

Why did the Apollo 13 crew extend the LM landing gear?

Start job from another SQL server instance

A factorization game

Install LibreOffice-Writer Only not LibreOffice whole package

SQlite delete query not working despite no errors

How to list the tables in a SQLite database file that was opened with ATTACH?How do I check in SQLite whether a table exists?Improve INSERT-per-second performance of SQLite?SQLite, can't delete columnsWhat are the best practices for SQLite on Android?Is there an SQLite equivalent to MySQL's DESCRIBE [table]?Delete an element from a dictionaryDelete a file or folderHow to delete or add column in SQLITE?Cannot delete the selected item from listview (values in sqlite)

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have SQLlite table set up as follows:

name = List
tablename = namesOfTests
two columns = testNames and dueDate

Please see link - https://sqliteonline.com/#fiddle-5c958b0c1ef9b54xjtktalx6

My code:

selectTest = "SampleSavedTest_Summ"
c1.execute("DELETE FROM namesOfTests WHERE testNames = ?;", (selectTest,))

The code runs with no errors, however, the database does not get updated. I would be grateful for some advice.

Please see comments below, @Parfait helped me fix it

python sqlite

share|improve this question

edited Mar 23 at 13:43

Arnoldddd

asked Mar 23 at 1:29

ArnolddddArnoldddd

14

• 
  
  
  

  
  3
  

  
  
  
  
  
  

  
  
  Did you commit() just after or run with autocommit in connection?
  
  – Parfait
  Mar 23 at 3:07
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Validate manually once if delete sql is framed correctly.. And check if applied sql is committed.
  
  – Giri
  Mar 23 at 5:08
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Parfait Thank youuuuuuuu I had forgottten to do that. This fixes the issue. it also helped me with some other issues I was having with the main program
  
  – Arnoldddd
  Mar 23 at 13:41
  

  
  
  
  

add a comment | 

0

I have SQLlite table set up as follows:

name = List
tablename = namesOfTests
two columns = testNames and dueDate

Please see link - https://sqliteonline.com/#fiddle-5c958b0c1ef9b54xjtktalx6

My code:

selectTest = "SampleSavedTest_Summ"
c1.execute("DELETE FROM namesOfTests WHERE testNames = ?;", (selectTest,))

The code runs with no errors, however, the database does not get updated. I would be grateful for some advice.

Please see comments below, @Parfait helped me fix it

python sqlite

share|improve this question

edited Mar 23 at 13:43

Arnoldddd

asked Mar 23 at 1:29

ArnolddddArnoldddd

14

• 
  
  
  

  
  3
  

  
  
  
  
  
  

  
  
  Did you commit() just after or run with autocommit in connection?
  
  – Parfait
  Mar 23 at 3:07
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Validate manually once if delete sql is framed correctly.. And check if applied sql is committed.
  
  – Giri
  Mar 23 at 5:08
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Parfait Thank youuuuuuuu I had forgottten to do that. This fixes the issue. it also helped me with some other issues I was having with the main program
  
  – Arnoldddd
  Mar 23 at 13:41
  

  
  
  
  

add a comment | 

I have SQLlite table set up as follows:

name = List
tablename = namesOfTests
two columns = testNames and dueDate

Please see link - https://sqliteonline.com/#fiddle-5c958b0c1ef9b54xjtktalx6

My code:

selectTest = "SampleSavedTest_Summ"
c1.execute("DELETE FROM namesOfTests WHERE testNames = ?;", (selectTest,))

The code runs with no errors, however, the database does not get updated. I would be grateful for some advice.

Please see comments below, @Parfait helped me fix it

python sqlite

share|improve this question

edited Mar 23 at 13:43

Arnoldddd

asked Mar 23 at 1:29

ArnolddddArnoldddd

14

name = List
tablename = namesOfTests
two columns = testNames and dueDate

selectTest = "SampleSavedTest_Summ"
c1.execute("DELETE FROM namesOfTests WHERE testNames = ?;", (selectTest,))

share|improve this question

edited Mar 23 at 13:43

Arnoldddd

asked Mar 23 at 1:29

ArnolddddArnoldddd

14

share|improve this question

edited Mar 23 at 13:43

Arnoldddd

asked Mar 23 at 1:29

ArnolddddArnoldddd

14

asked Mar 23 at 1:29

ArnolddddArnoldddd

14

asked Mar 23 at 1:29

ArnolddddArnoldddd

14