Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 9.3   9.4   9.5   10.0   10.1   10.2   10.3   10.4   10.5   10.6    Statistic    FMM    Blog  

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.InsertRecords
• FM.SQL.JSONColumn
• FM.SQL.JSONRecords
• FM.SQL.Max
• FM.SQL.Min
• FM.SQL.Sum
• FM.SQL.Text
• FM.SQL.XMLRecord
• FM.SQL.XMLRecords
• SQL.Execute

Example Databases

• SQL in FileMaker/ImageGallery
• SQL in FileMaker/SQL Select Container
• SQL to other databases/SQL Export
• Third Party/FileMaker Snippet Storage

Blog Entries

• 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

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.

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

FM.SQL.Min   -   FM.SQL.ReleaseAll

Feedback: Report problem or ask question.