Server Close statement - MapBasic - 2023

MapInfo MapBasic Reference

Product type
Software
Portfolio
Locate
Product family
MapInfo
Product
MapInfo > MapBasic
Version
2023
Language
English
Product name
MapBasic
Title
MapInfo MapBasic Reference
First publish date
1985
Last updated
2023-09-12
Published on
2023-09-12T16:32:32.686312

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