On Feb 11, 2010, at 12:08 PM, jflaming wrote: > > I'm new to SQLITE. > I'm trying to update a series of text entries for book titles that > were > entered with underscores. I want to convert them to spaces. > I can run the query: > > select replace(title, '_', ' ') from books; > > and see the output I'm looking for, but if I try to do an update > query and > actually perform the change: > > update books set title = replace(title, '_', ' '); > > it fails with this error: > Query Error: no such function: title_sort Unable to execute statement > > I'm sure I'm missing something simple here, but it's driving me > crazy... any > ideas?
Execute the ".schema" command from the shell tool and look at the output. You probably have a trigger defined on table books that uses the user-defined function title_sort. > > Jay > -- > View this message in context: > http://old.nabble.com/very-simple-update-query-failure...-tp27542440p27542440.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
