STOP-SQL-RECORDING
Prev | SQL I/O Recording | Next

## Name

STOP-SQL-RECORDING — Stop recording SQL commands or results.Function

## Syntax

          stop-sql-recording &key type database =>

## Arguments and Values

`type`

  One of the following keyword symbols: :commands, :results or :both, defaulting to :commands.

`database`

  A database object. This will default to *default-database*.

## Description

Stops recording of SQL commands sent to and/or results returned from `database` which defaults to *default-database*. The default value of `type` is :commands which means that SQL commands sent to `database` will no longer be recorded. If `type` is :results then SQL results returned from `database` will no longer be recorded. Recording may be stopped for both commands and results by passing `type` value of :both.

## Examples

    (start-sql-recording :type :both)
    =>
    (select [last-name] :from [employee]
                           :where [= [emplid] 1]
                           :field-names nil
                           :flatp t)
    ;; 2004-07-02 16:42:12 dent/test/dent => SELECT last_name FROM employee WHERE (emplid = 1)
    ;; 2004-07-02 16:42:12 dent/test/dent <= (Lenin)
    => ("Lenin")
    (stop-sql-recording :type :results)
    =>
    (select [last-name] :from [employee]
                           :where [= [emplid] 1]
                           :field-names nil
                           :flatp t)
    ;; 2004-07-02 16:44:11 dent/test/dent => SELECT last_name FROM employee WHERE (emplid = 1)
    => ("Lenin")

## Side Effects

The command and result recording broadcast streams associated with `database` are reinitialised to `NIL`.

## Affected by

None.

## Exceptional Situations

None.

## See Also

`start-sql-recording`
`sql-recording-p`

## Notes

None.

Prev | Up | Next
START-SQL-RECORDING | Home | SQL-RECORDING-P