Server Close statement - MapBasic - 2023

MapInfo MapBasic Reference

Product type
Software
Portfolio
Locate
Product family
MapInfo
Product
MapInfo > MapBasic
Version
2023
ft:locale
en-US
Product name
MapBasic
ft:title
MapInfo MapBasic Reference
First publish date
1985
ft:lastEdition
2023-09-12
ft:lastPublication
2023-09-12T16:32:32.686000

Purpose

Frees resources associated with running a remote data access statement. You can issue this statement from the MapBasic window in MapInfo Pro.

Syntax

Server StatementNumber Close

StatementNumber is an integer value that identifies information about a SQL statement.

Description

The Server Close statement is used to inform the server that processing on the current remote statement is finished. All resources associated with the statement are returned. Remember to call the Server Close statement immediately after a Server_Execute() function for any non-query SQL statement you are finished processing.

Example

' Fetch the 5th record then close the statement
hstmt = Server_Execute(hdbc, "Select * from Massive_Database")
Server hstmt Fetch Rec 5
Server hstmt Close

See Also:

Server_Execute() function