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.