All Manuals > LispWorks User Guide and Reference Manual > 47 The SQL Package

NextPrevUpTopContentsIndex

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-records changes 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-records
delete-records
insert-records
update-records-from-instance


LispWorks User Guide and Reference Manual - 20 Sep 2017

NextPrevUpTopContentsIndex