Xojo Developer Conference
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.

Platforms to show: All Mac Windows Linux Cross-Platform

SQLGlobalsMBS.GetEnv(name as string) as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
shared method SQL MBS SQL Plugin 13.0 Yes Yes Yes Yes No
Function: Queries environment variable.
Notes: Returns empty string if variable is undefined.

Feedback, Comments & Corrections

SQLGlobalsMBS.GetVersion as String
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
shared method SQL MBS SQL Plugin 14.2 Yes Yes Yes Yes No
Function: The version string of the SQLAPI library.

Feedback, Comments & Corrections

SQLGlobalsMBS.GetVersionBuild as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
shared method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The build number of the SQLAPI library.

Feedback, Comments & Corrections

SQLGlobalsMBS.GetVersionMajor as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
shared method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The major version number of the SQLAPI library.

Feedback, Comments & Corrections

SQLGlobalsMBS.GetVersionMinor as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
shared method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The minor version number of the SQLAPI library.

Feedback, Comments & Corrections

SQLGlobalsMBS.PutEnv(line as string) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
shared method SQL MBS SQL Plugin 13.0 Yes Yes Yes Yes No
Function: Sets environment variable.
Notes: Line format should be "key=value" and returns true on success and false on failure.

Feedback, Comments & Corrections

SQLGlobalsMBS.RaiseException(message as string)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
shared method SQL MBS SQL Plugin 13.1 Yes Yes Yes Yes No
Function: Raises an exception to test exception handling in SQL Plugin.
Notes: Raises directly a SQLErrorExceptionMBS with the given message.

Feedback, Comments & Corrections

SQLGlobalsMBS.RaiseSQLErrorException(UserCode as Integer, message as string)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
shared method SQL MBS SQL Plugin 13.1 Yes Yes Yes Yes No
Function: Raises an exception to test exception handling in SQL Plugin.
Notes: Raises a SAUserException which the plugin catches and translates to a SQLErrorExceptionMBS in Real Studio.

Feedback, Comments & Corrections

SQLGlobalsMBS.SetCurrentWorkingDirectory(path as folderitem) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
shared method SQL MBS SQL Plugin 16.0 Yes Yes Yes Yes No
Function: Sets the current working directory.
Notes: This is often useful to make sure the DLLs in that folder are found.

See also:

Feedback, Comments & Corrections

SQLGlobalsMBS.SetCurrentWorkingDirectory(path as String) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
shared method SQL MBS SQL Plugin 16.0 Yes Yes Yes Yes No
Function: Sets the current working directory.
Notes: This is often useful to make sure the DLLs in that folder are found.

See also:

Feedback, Comments & Corrections

SQLGlobalsMBS.SetEnv(name as string, value as string) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
shared method SQL MBS SQL Plugin 13.0 Yes Yes Yes Yes No
Function: Sets an environment variable.
Notes:
Existing variable with same name will be overwritten.
Returns true on success and false on failure.

Feedback, Comments & Corrections

SQLGlobalsMBS.SetLicenseCode(n as string, enddate as Integer, v1 as Integer, v2 as Integer)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
shared method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Registeres the SQL plugin and library.
Notes: Once you ordered a license, you receive details on how to call this method.

Feedback, Comments & Corrections

SQLGlobalsMBS.Setlocale(category as Integer, locale as string)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
shared method SQL MBS SQL Plugin 10.5 Yes Yes Yes Yes No
Function: Sets the locale to use.
Notes:
The Setlocale function sets the C library's notion of natural language formatting style for particular sets of routines. Each such style is called a 'locale' and is invoked using an appropriate name passed as a C string.

The setlocale() function recognizes several categories of routines. These are the categories and the sets of routines they select:

LocaleAllSet the entire locale generically.
LocaleCollateSet a locale for string collation routines. This controls alphabetic ordering in strcoll() and strxfrm().
LocaleCTypeSet a locale for the ctype and multibyte functions. This controls recognition of upper and lower case, alphabetic or non-alphabetic characters, and so on.
LocaleMessagesSet a locale for message catalogs, see catopen function.
LocaleMonetarySet a locale for formatting monetary values; this affects the localeconv() function.
LocaleNumericSet 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().
LocaleTimeSet a locale for formatting dates and times using the strftime() function.

Only three locales are defined by default: the empty string "" (which denotes the native environment) and the "C" and "POSIX" locales (which denote the C-language environment). By default, C programs start in the "C" locale.

Feedback, Comments & Corrections

SQLGlobalsMBS.UnSetEnv(name as string) as boolean
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
shared method SQL MBS SQL Plugin 13.0 Yes Yes Yes Yes No
Function: Removes environment variable.
Notes: Returns true on success and false on failure.

Feedback, Comments & Corrections

The items on this page are in the following plugins: MBS SQL Plugin.




Links
MBS FileMaker Plugins