Close()


" "

short Close(long QueryID)

Description

This function closes a query and invalidates QueryID. If there is a cursor open for the query, the cursor is closed, which frees the database for other users. This function does not terminate the connection to the database server. Because the connection remains open, no rollback or commit is performed.

Note:
The name of this function conflicts with the Microsoft Access 2.0 keyword Execute. If you are using MS Access 2.0, place square brackets [] around the function name.

Parameters

Name Description
QueryID The ID of the query, as returned from InitializeQuery().

Return Value

The return value will be zero if successful or non-zero if unsuccessful. If the return value is non-zero, you can call GetLastErrorString(), GetLastErrorType(), GetLastSQLCode(), GetLastSQLError(), or GetLastSQLState() to get additional error information.

Related Tasks

Execute()
ExecuteEx()
ExecuteStoredProcedure()
ExecuteStoredProcedureEx()
Open()