Name

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

Function

Syntax

      stop-sql-recording &key type 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.

Notes

None.