SQL.InternalSQLiteLibrary.Activate
----------------------------------

Activates the internal SQLite library.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [SQL](component_SQL.md) | [5.3](newinversion53.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "SQL.InternalSQLiteLibrary.Activate" ) ### Parameters

none

### Result

Returns OK or error.

### Description

Activates the internal SQLite library.  
If you use this command, you don't need to provide sqlite3.dll or sqlite3.dylib yourself.  
  
Our internal SQLite library includes the following extensions:  
  
- JSON1, the extension to provide [JSON](component_JSON.md) functions
- FTS5, the full text search extension in version 5
- R\*Tree index extension
- SOUNDEX function
- SQL [math](component_Math.md) functions
- Geopoly extension
- ICU extension for unicode handling
- The RBU Extension
- SQLite Encryption Extension

You can turn on these SQLite extensions at runtime with MBS Plugin:  
  
- UUID extension
- Base64 extension
- CSV extension

More extensions could be added on request.  
### Examples

Activate the internal SQLite library if not already activated:

 If \[MBS ( "[SQL.InternalSQLiteLibrary.Activated](SQLInternalSQLiteLibraryActivated.md)" ) ≠ 1\]  
 Set Variable \[$r ; Value:MBS ( "SQL.InternalSQLiteLibrary.Activate" )\]  
End If  
Enable all extensions and activate:

 Set Variable \[$r ; Value: MBS ( "[SQL.InternalSQLiteLibrary.SetBase64ExtensionEnabled](SQLInternalSQLiteLibrarySetBase64ExtensionEnabled.md)"; 1 )\]  
Set Variable \[$r ; Value: MBS ( "[SQL.InternalSQLiteLibrary.SetCSVExtensionEnabled](SQLInternalSQLiteLibrarySetCSVExtensionEnabled.md)"; 1 )\]  
Set Variable \[$r ; Value: MBS ( "[SQL.InternalSQLiteLibrary.SetICUEnabled](SQLInternalSQLiteLibrarySetICUEnabled.md)"; 1 )\]  
Set Variable \[$r ; Value: MBS ( "[SQL.InternalSQLiteLibrary.SetUUIDExtensionEnabled](SQLInternalSQLiteLibrarySetUUIDExtensionEnabled.md)"; 1 )\]  
Set Variable \[$r ; Value: MBS ( "SQL.InternalSQLiteLibrary.Activate" ) \]  
### See also

- [SQL.ClientVersion](SQLClientVersion.md)
- [SQL.InternalSQLiteLibrary.Activated](SQLInternalSQLiteLibraryActivated.md)
- [SQL.InternalSQLiteLibrary.ICUUsed](SQLInternalSQLiteLibraryICUUsed.md)
- [SQL.InternalSQLiteLibrary.LoadICU](SQLInternalSQLiteLibraryLoadICU.md)
- [SQL.InternalSQLiteLibrary.SetBase64ExtensionEnabled](SQLInternalSQLiteLibrarySetBase64ExtensionEnabled.md)
- [SQL.InternalSQLiteLibrary.SetCSVExtensionEnabled](SQLInternalSQLiteLibrarySetCSVExtensionEnabled.md)
- [SQL.InternalSQLiteLibrary.SetICUEnabled](SQLInternalSQLiteLibrarySetICUEnabled.md)
- [SQL.InternalSQLiteLibrary.SetUUIDExtensionEnabled](SQLInternalSQLiteLibrarySetUUIDExtensionEnabled.md)
- [SQL.InternalSQLiteLibrary.SourceID](SQLInternalSQLiteLibrarySourceID.md)
- [SQL.InternalSQLiteLibrary.Version](SQLInternalSQLiteLibraryVersion.md)

### Release notes

- **Version 15.3**
    - Added CSV extension for the built-in SQLite library in [SQL.InternalSQLiteLibrary.Activate](https://www.mbsplugins.eu/SQLInternalSQLiteLibraryActivate.shtml) function.
    - Added uuid and base64 extensions for the built-in SQLite library in [SQL.InternalSQLiteLibrary.Activate](https://www.mbsplugins.eu/SQLInternalSQLiteLibraryActivate.shtml) function.
- **Version 11.2**
    - Enabled math and geopoly functions for internal SQLite library. see [SQL.InternalSQLiteLibrary.Activate](https://www.mbsplugins.eu/SQLInternalSQLiteLibraryActivate.shtml)

### Example Databases

- [SQL in FileMaker/Insert or Update Tests](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/SQL%20in%20FileMaker/Insert%20or%20Update%20Tests.shtml#14ScriptAnchor_)
- [SQL to other databases/SQL Export](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/SQL%20to%20other%20databases/SQL%20Export.shtml#1ScriptAnchor_)
- [SQL to other databases/SQLite blob](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/SQL%20to%20other%20databases/SQLite%20blob.shtml#4ScriptAnchor_)
- [SQL to other databases/SQLite fun](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/SQL%20to%20other%20databases/SQLite%20fun.shtml#4ScriptAnchor_)
- [Third Party/FileMaker Snippet Storage](https://www.mbsplugins.eu/MBS-FileMaker-Plugin-Examples/Third%20Party/FileMaker%20Snippet%20Storage.shtml#39CustomFunctionAnchor_)

### Blog Entries

- [MBS FileMaker Plugin, version 15.3pr2](https://www.mbsplugins.de/archive/2025-06-09/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)
- [Connect to an external database server in FileMaker](https://www.mbsplugins.de/archive/2022-03-11/Connect_to_an_external_databas/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 11.2pr1](https://www.mbsplugins.de/archive/2021-04-01/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)
- [MBS FileMaker Plugin, version 11.1pr8](https://www.mbsplugins.de/archive/2021-03-04/MBS_FileMaker_Plugin_version_1/monkeybreadsoftware_blog_filemaker)
- [\[ANN\] MBS FileMaker Plugin 5.3 for OS X/Windows](https://www.mbsplugins.de/archive/2015-10-01/[ANN]_MBS_FileMaker_Plugin_53_/monkeybreadsoftware_blog_filemaker)

This function checks for a license.

Created 23th September 2015 , last changed 30th June 2025

  
[SQL.InsertRecords](SQLInsertRecords.md) - [SQL.InternalSQLiteLibrary.Activated](SQLInternalSQLiteLibraryActivated.md)

[HTML Version](SQLInternalSQLiteLibraryActivate.shtml)