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.SetSQLBatchMode

Sets turbo level for sending SQL in chunks.

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

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

• Dialog.SetTop
• FM.GetSQLBatchMode
• FM.InsertRecord
• FM.InsertRecordQuery
• ProgressDialog.Hide
• ProgressDialog.Reset
• ProgressDialog.SetProgress
• ProgressDialog.SetTopText
• ProgressDialog.Show
• ProgressDialog.Update

Blog Entries

• MBS FileMaker Plugin, version 6.4pr8

Created 17th September 2016, last changed 12nd November 2018

FM.SetDisableContextualMenus   -   FM.SetThreadName

Feedback: Report problem or ask question.