Differences between revisions 1 and 10 (spanning 9 versions)
⇤ ← Revision 1 as of 2018-03-27 21:14:53 →
Size: 82
Editor: grover5
Comment:
← Revision 10 as of 2018-03-27 21:47:16 → ⇥
Size: 544
Editor: grover5
Comment:
Deletions are marked like this. Additions are marked like this.
Line 4: Line 4:

= 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`

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

None: CollabTest2/FormsDict (last edited 2018-03-27 21:47:16 by grover5)