Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server (Not)   Client   Old   Guides   Examples
New in version: 6.2   6.3   6.4   6.5   7.0   7.1   7.2   7.3   7.4   7.5    Statistic  

FM.SetSQLBatchMode

Sets turbo level for sending SQL in chunks.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
FM FMSQL 6.4 Yes Yes Yes Yes Yes

MBS( "FM.SetSQLBatchMode"; Value )

Parameters

Parameter Description Example value
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.

Examples

Move records, 50 inserts per chunk:

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

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

See also


FM.ScriptNames   -   FM.SetThreadName

Feedback: Report problem or ask question.




Links
MBS Xojo Plugins