Delete SQLite record

[Jerry Muelver]

Trying to delete a record in the runwiki database:

[deletePage]
     call connect
     #wiki execute("delete from pages where NAME = """; currentName$; """")
     call disconnect
      cls
      print currentName$;" deleted. ";
      link #home, "HOME", loadPage
      #home setkey("HOME")
      wait
wait

I get a "database is locked" error on the #wiki execute statement. Am I missing something extra for the DELETE to work, like an UPDATE or something?

[mikeukmid]

Works ok for me!

I copied/pasted your code into 'runwiki' and was able to add and then delete records from the database.

[Jerry Muelver]

I guess I'm a better coder than I thought I was, then. I'll look for a failure to disconnect from the table in the setup leading to the delete attempt. I'm playing a little wild and woolly with SUBs and branches at the moment.