16 The SQL Package
update-records
Function
- Summary
- Changes the values of fields in a table.
- Package
sql- Signature
update-records table &key attributes values av-pairs where database =>- Arguments
-
- table
A database table.
- attributes
A set of columns.
- values
A set of values.
- av-pairs
An association list alternative to attributes and values.
- where
A condition.
- database
A database.
- Values
- None.
- Description
- The function
update-recordschanges the values of existing fields in table with columns specified by attributes and values (or av-pairs) where the where condition is true. - See also
delete-instance-recordsdelete-recordsinsert-recordsupdate-records-from-instance