Platforms to show: All Mac Windows Linux Cross-Platform
SQLGlobalsMBS class
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| class | SQL | MBS SQL Plugin | 9.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
- event Trace(traceInfo as Integer, SQL as string, Connection as SQLConnectionMBS, Command as SQLCommandMBS)
- 16 shared methods
- shared method FindTableName(SQL as String) as String
- shared method GetEnv(name as string) as string
- shared method GetVersion as String
- shared method GetVersionBuild as Integer
- shared method GetVersionMajor as Integer
- shared method GetVersionMinor as Integer
- shared method PutEnv(line as string) as boolean
- shared method RaiseException(message as string)
- shared method RaiseSQLErrorException(UserCode as Integer, message as string)
- shared method SetCurrentWorkingDirectory(path as folderitem) as boolean
- shared method SetCurrentWorkingDirectory(path as String) as boolean
- shared method SetEnv(name as string, value as string) as boolean
- shared method SetLicenseCode(n as string, enddate as Integer, v1 as Integer, v2 as Integer)
- shared method Setlocale(category as Integer, locale as string)
- shared method UnInitialize
- shared method UnSetEnv(name as string) as boolean
- 7 constants
Constants
| Constant | Value | Description |
|---|---|---|
| LocaleAll | 0 |
One of the locale category constants for SetLocale.
Set the entire locale generically. |
| LocaleCollate | 1 |
One of the locale category constants for SetLocale.
Set a locale for string collation routines. This controls alphabetic ordering in strcoll() and strxfrm(). |
| LocaleCType | 2 |
One of the locale category constants for SetLocale.
et a locale for the ctype(3) and multibyte(3) functions. This controls recognition of upper and lower case, alphabetic or non-alphabetic characters, and so on. |
| LocaleMessages | 6 |
One of the locale category constants for SetLocale.
Set a locale for message catalogs, see catopen(3) function. |
| LocaleMonetary | 3 |
One of the locale category constants for SetLocale.
Set a locale for formatting monetary values; this affects the localeconv() function. |
| LocaleNumeric | 4 |
One of the locale category constants for SetLocale.
Set a locale for formatting numbers. This controls the formatting of decimal points in input and output of floating point numbers in functions such as printf() and scanf(), as well as values returned by localeconv(). |
| LocaleTime | 5 |
One of the locale category constants for SetLocale.
Set a locale for formatting dates and times using the strftime() function. |
This class has no sub classes.
Some methods using this class:
- SQLDatabaseMBS.Constructor(globals as SQLGlobalsMBS = nil)
Some examples using this class:
- /SQL/Environment Test
- /SQL/SQL Exception Tests
- /SQL/SQLDatabaseMBS SQL Anywhere Connect
- /SQL/SQLite select version with Trace events
Blog Entries
- News from the MBS Xojo Plugins Version 21.1
- MBS Xojo Plugins, version 21.1pr2
- MBS Xojo Plugins, version 21.1pr1
- Edit and Update for SQLDatabaseMBS class
- Register MBS Xojo Plugins
- MBS Xojo / Real Studio Plugins, version 13.5pr3
- MBS Real Studio Plugins, version 13.0pr7
- Accessing Microsoft SQL Database from Mac/Linux
- SQL Plugin and Textencoding
Release notes
- Version 21.1
- Added FindTableName function to SQLGlobalsMBS class.
- Added UnInitialize method to SQLGlobalsMBS class.
The items on this page are in the following plugins: MBS SQL Plugin.
