SQLite Forum

edit() function usage
Login
I'm running on a Mac and am having some issues with the edit() function. BBEdit is my default editor but I also have the native TextEdit available. I can get it almost working with
'update books set notes=edit(notes,'BBEDIT') WHERE id=1;'
which does open BBEdit with the requested document loaded. But when I save and quit the editor it does not update the text in the DB.

Is there something I'm missing?