Database Connection
- .type
sqlite
- .file
attachment:CollabTest2.db
Form
- .select
select * from Information order by LastName
.update:: update Information set LastName=%s, FirstName=%s, AgeInMonths=%d where Id=?
- .update_parameters
.LastName, .FirstName, .AgeInMonths, .Id
- .insert
insert into Information(LastName, FirstName, AgeInMonths) values(%s, %s, %d)
- .insert_parameters
.LastName, .FirstName, .AgeInMonths
- .delete
delete from Information where Id=?
- .delete_parameters
.Id