Next Prev Up Top Contents Index

commit

Function
Summary

Commits changes made to a database.

Package

sql

Signature

commit &key database => nil

Arguments

database

A database.

Values

nil

Description

The commit function commits changes made to the database specified by database , which is *default-database* by default.

Example

In the next example, changes records in a database, and commit is used to make those changes permanent.

 (insert-records :into [emp]
                :attributes '(x y z)
                :values '(a b c))
 (update-records [emp]
    :attributes [dept]
    :values 50
    :where [= [dept] 40])
 (delete-records :from [emp]
    :where [> [salary] 300000])
 (commit)
See also

rollback
with-transaction


LispWorks Reference Manual (Windows version) - 14 Dec 2001

Next Prev Up Top Contents Index