FM.SQL.Release

Releases memory used for the SQL result.

Parameters

Parameter	Description	Example
SQLref	The reference number returned by FM.SQL.Execute function.	$SQLRef

Result

Returns OK or error.

Description

Examples

Run command and free it later:

$ref = MBS( "FM.SQL.Execute"; ""; "SELECT * FROM ProductImages FETCH FIRST 1 ROWS ONLY")
...
$r = MBS( "FM.SQL.Release"; $ref )

See also

• FM.SQL.JSONColumn
• FM.SQL.JSONRecords
• FM.SQL.Max
• FM.SQL.Min
• FM.SQL.RowCount
• FM.SQL.Text
• FM.SQL.XMLRecord
• FM.SQL.XMLRecords
• JSON.ReplaceEvaluate
• SQL.Execute

Release notes

• Version 10.5
  • Added AVExport.ReleaseAll, AVRecorder.ReleaseAll, CoreML.ReleaseAll, DNSLookup.ReleaseAll, Dictionary.ReleaseAll, FM.SQL.ReleaseAll, JS.ReleaseAll, JavaScript.ReleaseAll, LDAP.ReleaseAll, PDFKit.ReleaseAll, PKCS12.ReleaseAll, PKCS7.ReleaseAll, PKey.ReleaseAll, SSH.ReleaseAll, WinSendMail.ReleaseAll, WindowsML.ReleaseAll, WordFile.ReleaseAll, and X509.ReleaseAll.

Example Databases

• DynaPDF/Extract Images
• SQL in FileMaker/ImageGallery
• SQL in FileMaker/SQL Select Container
• SQL to other databases/ODBC Query
• SQL to other databases/SQL Export
• Third Party/FileMaker Snippet Storage

Blog Entries

• JSON Replace with evaluate
• Moving data from ODBC to FileMaker via script
• Sending email with a huge custom function
• FileMaker records to XML or JSON
• Query FileMaker records as JSON
• FileMaker SQL with Sum, Min, Max and Avg on results
• Image Gallery in FileMaker using SQL
• FileMaker Custom function to query a value from other table or file
• Execute SQL in FileMaker and get back native field types

This function checks for a license.

Created 18th April 2015, last changed 1st August 2016

FM.SQL.Min - FM.SQL.ReleaseAll