Dennis
Do you have an example on how to do this?
Steve
Dennis Cote wrote:
Steve Frierdich wrote:
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