SQLGlobalsMBS.FindTableName(SQL as String) as String

Var sql As String = "SELECT First, Last FROM MyTable WHERE ID = 1"
Var TableName As String = SQLGlobalsMBS.FindTableName(sql)

MessageBox TableName // shows MyTable

This is a helper function used by our Edit/Update methods in RecordSet.
Returns either the found table name or empty text if something got wrong. e.g. multiple tables affected due to JOIN operation.

If you find a case where the parser crashes or reports wrong result, please contact us.

SQLGlobalsMBS.GetEnv(name as string) as string

Returns empty string if variable is undefined.

SQLGlobalsMBS.GetVersion as String

SQLGlobalsMBS.GetVersionBuild as Integer

SQLGlobalsMBS.GetVersionMajor as Integer

SQLGlobalsMBS.GetVersionMinor as Integer

SQLGlobalsMBS.PutEnv(line as string) as boolean

Line format should be "key=value" and returns true on success and false on failure.

SQLGlobalsMBS.RaiseException(message as string)

Raises directly a SQLErrorExceptionMBS with the given message.

SQLGlobalsMBS.RaiseSQLErrorException(UserCode as Integer, message as string)

Raises a SAUserException which the plugin catches and translates to a SQLErrorExceptionMBS in Xojo.

Some examples using this method:

• /SQL/SQL Exception Tests

SQLGlobalsMBS.SetCurrentWorkingDirectory(path as folderitem) as boolean

This is often useful to make sure the DLLs in that folder are found.

See also:

• SetCurrentWorkingDirectory(path as String) as boolean

SQLGlobalsMBS.SetCurrentWorkingDirectory(path as String) as boolean

This is often useful to make sure the DLLs in that folder are found.

See also:

• SetCurrentWorkingDirectory(path as folderitem) as boolean

SQLGlobalsMBS.SetEnv(name as string, value as string) as boolean

Existing variable with same name will be overwritten.
Returns true on success and false on failure.

SQLGlobalsMBS.SetLicenseCode(n as string, enddate as Integer, v1 as Integer, v2 as Integer)

Once you ordered a license, you receive details on how to call this method.

SQLGlobalsMBS.Setlocale(category as Integer, locale as string)

// ask for English for USA with 1252 codepage
SQLGlobalsMBS.Setlocale SQLGlobalsMBS.LocaleAll, "English_United States.1252"

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:

LocaleAll	Set the entire locale generically.
LocaleCollate	Set a locale for string collation routines. This controls alphabetic ordering in strcoll() and strxfrm().
LocaleCType	Set a locale for the ctype and multibyte functions. This controls recognition of upper and lower case, alphabetic or non-alphabetic characters, and so on.
LocaleMessages	Set a locale for message catalogs, see catopen function.
LocaleMonetary	Set a locale for formatting monetary values; this affects the localeconv() function.
LocaleNumeric	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	Set 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.

SQLGlobalsMBS.UnInitialize

You can call this in App Close or Destructor, but only after you destroyed all Connections, e.g. all SQLDatabaseMBS and SQLConnectionMBS objects.

SQLGlobalsMBS.UnSetEnv(name as string) as boolean

Returns true on success and false on failure.

Some examples using this method:

• /SQL/Environment Test