SQLite Forum

User Defined Functions
Login
> Anyone has a worked example (of something simple, like adding a number to an existing column in a table in the current connection) of using sqlite3_create_function? I can adapt the template for my purposes.

This is not normally what a function does.  A function is like a toaster.  You put something in (raw bread) and something else comes out (toasted bread).  While a toaster may have "side-effects" (such as burning down your house) these are generally not the primary function of the toaster.

In an SQL database the way to update a value in a table is with the UPDATE statement.  While you may write a function that takes raw bread and make toast and at the same time tallies up the number of slices of bread toasted in some table as a side-effect, but that would greatly limit the utility of the function.