Monkeybread Software - MBS FileMaker Plugin: SQL Select Container

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

MBS FileMaker Plugin Example Databases

SQL Select Container

All examples are included with download of MBS FileMaker Plugin.

SQL Select Container.fmp12

Overview
Tables	1
Relationships	0
Layouts	1
Scripts	4
Value Lists	0
Custom Functions	0
Custom Menus	33

File Options
Default custom menu set	[Standard FileMaker Menus]
When opening file
Minimum allowed version	12.0
Login using	Account Name; Account= Admin
Allow user to save password	Off
Require iOS passcode	Off
Switch to layout	Off
Hide all toolbars	Off
Script triggers
OnFirstWindowOpen	Off
OnLastWindowClose	Off
OnWindowOpen	Off
OnWindowClose	Off
OnFileAVPlayerChange	Off
Thumbnail Settings
Generate Thumbnails	On; Temporary

Tables

Table Name	Statistics	Occurrences in Relationship Graph
SQL Select Container	6 fields defined, 2 records	SQL Select Container

Fields

Table Name: SQL Select Container - 6 Fields
Field Name	Type	Options	Comments	On Layouts	In Relationships	In Scripts	In Value Lists
myName	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1 Indexing: Minimal Automatically create indexes as needed Index Language: German		SQL Select Container
myContainer	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Repetitions: 1		SQL Select Container
gName	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		SQL Select Container		Run Clear Insert Test
gContainer	Normal, Binary	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1		SQL Select Container		Run Clear Insert Test
myRecordID	Normal, Text	Auto-Enter: Allow editing Context table: SQL Select Container Calculation: Get(RecordID) Validation: Only during data entry Storage: Repetitions: 1 Indexing: None Automatically create indexes as needed Index Language: German		SQL Select Container
gSQL	Normal, Text	Auto-Enter: Allow editing Validation: Only during data entry Storage: Global Repetitions: 1 Index Language: German		SQL Select Container		Run

Layout Objects: SQL Select Container

Regular Fields

Field Name: SQL Select Container::myName

Layout Name:

SQL Select Container

Top: 186 pt
Left: 138 pt
Bottom: 200 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: SQL Select Container::myContainer

Layout Name:

SQL Select Container

Top: 204 pt
Left: 138 pt
Bottom: 329 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Field Name: SQL Select Container::gName

Layout Name:

SQL Select Container

Top: 24 pt
Left: 138 pt
Bottom: 38 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Field Name: SQL Select Container::gContainer

Layout Name:

SQL Select Container

Top: 42 pt
Left: 138 pt
Bottom: 167 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Field Name: SQL Select Container::myRecordID

Layout Name:

SQL Select Container

Top: 330 pt
Left: 138 pt
Bottom: 344 pt
Right: 391 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Yes

Field Name: SQL Select Container::gSQL

Layout Name:

SQL Select Container

Top: 18 pt
Left: 480 pt
Bottom: 62 pt
Right: 871 pt

Anchoring: Left, Top

Field Format:

Edit Box

Field Behavior:

Allow field to be entered: In Find mode, In Browse mode
Touch keyboard type: System Default
Go to next field using: Tab key

Type:

Text: Execute SQL

Layout Name:

SQL Select Container

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 84 pt
Left: 480 pt
Bottom: 109 pt
Right: 613 pt

Anchoring: Left, Top

Perform Script [ “Run” ]

Scripts:

Button Properties

Coordinates

Script/Script Step

Type:

Text: Clear

Layout Name:

SQL Select Container

Additional Properties:

Change to hand cursor over button
Rectangular

Top: 84 pt
Left: 660 pt
Bottom: 109 pt
Right: 793 pt

Anchoring: Left, Top

Perform Script [ “Clear” ]

Scripts:

Clear

Insert with Query Test

Next Script: [Clear]

Script Name	Run
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	SQL Select Container
Scripts that use this script
Script Definition
Script Steps	#trace on Set Variable [ $r; Value:MBS("Trace") ] #run sql Set Variable [ $SQL; Value:MBS("FM.SQL.Execute"; ""; SQL Select Container::gSQL) ] If [ MBS("IsError") ] Show Custom Dialog [ Title: "Error"; Message: $SQL; Default Button: “OK”, Commit: “Yes”; Button 2: “Cancel”, Commit: “No” ] Exit Script [ ] End If # query some interesting facts about result Set Variable [ $rowCount; Value:MBS("FM.SQL.RowCount"; $SQL) ] Set Variable [ $fieldCount; Value:MBS("FM.SQL.FieldCount"; $SQL) ] Set Variable [ $fieldTypeFirstFieldFirstRow; Value:MBS("FM.SQL.FieldType"; $SQL; 0; 0) ] Set Variable [ $fieldTypeSecondFieldFirstRow; Value:MBS("FM.SQL.FieldType"; $SQL; 0; 1) ] Set Variable [ $fieldValueFirstFieldFirstRow; Value:MBS("FM.SQL.Field"; $SQL; 0; 0) ] Set Variable [ $fieldValueSecondFieldFirstRow; Value:MBS("FM.SQL.Field"; $SQL; 0; 1) ] # and show in global fields Set Field [ SQL Select Container::gName; $fieldValueFirstFieldFirstRow ] Set Field [ SQL Select Container::gContainer; $fieldValueSecondFieldFirstRow ] # cleanup Set Variable [ $r; Value:MBS("FM.SQL.Release"; $SQL) ]
Fields used in this script	SQL Select Container::gSQL SQL Select Container::gName SQL Select Container::gContainer
Scripts used in this script
Layouts used in this script
Tables used in this script	SQL Select Container
Table occurrences used by this script	SQL Select Container
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Run]

Next Script: [Insert Test]

Script Name	Clear
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script	SQL Select Container
Scripts that use this script
Script Definition
Script Steps	Set Field [ SQL Select Container::gName; "" ] Set Field [ SQL Select Container::gContainer; "" ]
Fields used in this script	SQL Select Container::gName SQL Select Container::gContainer
Scripts used in this script
Layouts used in this script
Tables used in this script	SQL Select Container
Table occurrences used by this script	SQL Select Container
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Clear]

Next Script: [Insert with Query Test]

Script Name	Insert Test
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	#make new record with current items in global fields. Set Variable [ $r; Value:MBS( "FM.InsertRecord"; Get(FileName); "SQL Select Container"; "myName"; SQL Select Container::gName; "myContainer"; SQL Select Container::gContainer ) ]
Fields used in this script	SQL Select Container::gName SQL Select Container::gContainer
Scripts used in this script
Layouts used in this script
Tables used in this script	SQL Select Container
Table occurrences used by this script	SQL Select Container
Custom Functions used by this script
Custom menu set used by this script

Previous Script: [Insert Test]

Script Name	Insert with Query Test
Run script with full access privileges	Off
Include In Menu	Yes
Layouts that use this script
Scripts that use this script
Script Definition
Script Steps	#Make new records with existing records. Set Variable [ $r; Value:MBS( "FM.InsertRecordQuery"; Get(FileName); "SQL Select Container"; "myName¶myContainer"; Get(FileName); "SELECT myName, myContainer from \"SQL Select Container\"") ]
Fields used in this script
Scripts used in this script
Layouts used in this script
Tables used in this script
Table occurrences used by this script
Custom Functions used by this script
Custom menu set used by this script

Download example: SQL Select Container

Used functions: