Anyone know of any links or have example on how to create a stored procedure and how to use that stored procedure in code on a sqlite database? Thanks Steve
As someone pointed out earlier, SQLite does not support stored procedures.
You can store SQL scripts in text files, or in a table in the database. Your application can then retrieve the scripts and execute them whenever necessary. Its not the same as a stored procedure, but it is often all that is needed.
HTH
Dennis Cote
