Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

FM.SetSQLBatchMode

Sets turbo level for sending SQL in chunks.

Component Version macOS Windows Linux Server iOS SDK
FM FMSQL 6.4 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes

Deprecated

This function was deprecated.

MBS( "FM.SetSQLBatchMode"; Value )   More

Parameters

Parameter Description Example
Value The chunk size.
Default is 1, but 10 or 50 is usually faster.		 1

Result

Returns OK or error.

Description

Sets turbo level for sending SQL in chunks.
For use in FM.InsertRecordQuery.
(others could be added)

Our plugin can send several SQL commands in one chunk which makes some operation much faster.
Instead of doing one record at a time with insert and commit, we can e.g. do 50 inserts and then one commit.

Examples

Move records, 50 inserts per chunk:

Set Variable [ $r ; Value: MBS( "ProgressDialog.Reset") ]
Set Variable [ $r ; Value: MBS( "ProgressDialog.SetTitle"; "Please wait." ) ]
Set Variable [ $r ; Value: MBS( "ProgressDialog.SetTopText"; "Copying records..." ) ]
Set Variable [ $r ; Value: MBS( "ProgressDialog.Show" ) ]
Set Variable [ $r ; Value: MBS( "ProgressDialog.SetProgress"; 0 ) ]
Set Variable [ $r ; Value: MBS( "ProgressDialog.Update" ) ]

Set Variable [ $r ; Value: MBS( "FM.SetSQLBatchMode"; 50) ]
Set Variable [ $r ; Value: MBS( "FM.InsertSetUpdateProgressDialog"; 1) ]
Set Variable [ $r ; Value: MBS( "FM.InsertRecordQuery"; ""; "dest"; $FieldNames; ""; "SELECT \"f1\", \"f2\", \"f3\", \"f4\", \"f5\", \"f6\", \"f7\",… ]
Set Variable [ $r ; Value: MBS( "ProgressDialog.Hide") ]

See also

Release notes

Blog Entries

This function is free to use.

Created 17th September 2016, last changed 21st January 2026


FM.SetDisableContextualMenus - FM.SetThreadName