Function

Summary

Sets the values of the bind variables in a prepared-statement.

Package

sql

Signature

set-prepared-statement-variables prepared-statement &key database values => prepared-statement

Arguments

prepared-statement

A prepared-statement.

database

A database or nil.

values

A list.

Description

The function set-prepared-statement-variables sets the values of the bind variables in the prepared-statement prepared-statement to the objects in the list given by values. The length of values must equal the number of bind-variables in the prepared-statement (that is, the supplied or computed count in prepare-statement). If database is supplied, then the prepared-statement is (re)associated with that database.

If database is not supplied and the statement is not associated with a database yet, set-prepared-statement-variables associates it with the default database *default-database*. If the statement was already associated and database is nil, the association does not change.

set-prepared-statement-variables returns the prepared-statement.

See also

prepare-statement
destroy-prepared-statement