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.