Database Connection

.type

sqlite

.file

attachment:Recipes.db

Form

.select

select * from Recipes order by Name

.update

update Recipes set Name=?, Category=?, Servings=?, Energy=?, Time=?, Difficulty=?, Procedure=? where Id=?

.update_parameters

.Name, .Category, .Servings, .Energy, .Time, .Difficulty, .Procedure, .Id

.insert

insert into Recipes(Name, Category, Servings, Energy, Time, Difficulty, Procedure) values(?, ?, ?, ?, ?, ?, ?)

.insert_parameters

.Name, .Category, .Servings, .Energy, .Time, .Difficulty, .Procedure

.delete

delete from Recipes where Id=?

.delete_parameters

.Id

There are 1 attachment(s) stored for this page.