FinishDatabaseQuery()

Syntax

FinishDatabaseQuery(#Database)

Finish the current database SQL query and release its associated resources. Query related functions like FirstDatabaseRow() or NextDatabaseRow() can't be used anymore.

Parameters

#Database

The database to use.

Return value

None.

Example

  ; First, connect to a database with an employee table
  ;
  If DatabaseQuery(#Database, "SELECT * FROM employee") ; Get all the records in the 'employee' table
  
    While NextDatabaseRow(#Database) ; Loop for each records
      Debug GetDatabaseString(#Database, 0) ; Display the content of the first field      
    Wend
    
    FinishDatabaseQuery(#Database)
  EndIf

See Also

DatabaseQuery()

Supported OS

All