Event fired after a query or stored procedure is successfully closed.

Parameters

none

Property of

Query, StoredProc

Description

An attempt to close a query or stored procedure occurs when its active property, or the active property of the objectís database, is set to false. If the objectís rowset has been modified, dBASE Plus will try to save it, so the close attempt can be canceled by the rowsetís canSave event handler. If not, the row is saved.

The close can also be prevented by the Query or StoredProc objectís canClose event handler. If not, the object is closed, and its onClose event fires.

Because onClose fires after the rowset has closed, you can no longer affect its fields. If you want to do something with the rowsetís data when the rowset closes, use the canClose event instead, and have the event handler return true.