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

SQLStringMBS.Compare(text as SQLStringMBS) as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Compares this string object with another string.
Notes:
Function performs a case-sensitive comparison of the strings, and is not affected by locale.

Returns zero if the strings are identical, < 0 if this string object is less than text, or > 0 if this string object is greater than text.

See also:

Feedback, Comments & Corrections

SQLStringMBS.Compare(text as string) as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Compares this string object with another string.
Notes:
Function performs a case-sensitive comparison of the strings, and is not affected by locale.

Returns zero if the strings are identical, < 0 if this string object is less than text, or > 0 if this string object is greater than text.

See also:

Feedback, Comments & Corrections

SQLStringMBS.CompareNoCase(text as SQLStringMBS) as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Compares this string object with another string.
Notes:
Function performs a case-insensitive comparison of the strings, and is not affected by locale.

Returns zero if the strings are identical (ignoring case), <0 if this string object is less than text (ignoring case), or >0 if this string object is greater than text (ignoring case).

See also:

Feedback, Comments & Corrections

SQLStringMBS.CompareNoCase(text as string) as Integer
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Compares this string object with another string.
Notes:
Function performs a case-insensitive comparison of the strings, and is not affected by locale.

Returns zero if the strings are identical (ignoring case), <0 if this string object is less than text (ignoring case), or >0 if this string object is greater than text (ignoring case).

See also:

Feedback, Comments & Corrections

SQLStringMBS.Constructor
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Creates a new empty string object.

See also:

Feedback, Comments & Corrections

SQLStringMBS.Constructor(Data as MemoryBlock)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 15.2 Yes Yes Yes Yes No
Function: Creates a new string object with data, e.g. for blob.

See also:

Feedback, Comments & Corrections

SQLStringMBS.Constructor(Data as string, isText as Boolean = True)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Creates a new string object with data or text copied from the data string.
Notes: If isText is true, the data is interpreted as text and string encoding conversion may modify it. If isText is false the bytes are copied raw.

See also:

Feedback, Comments & Corrections

SQLStringMBS.Constructor(other as SQLStringMBS)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Creates a new string object with data copied from the other string object.

See also:

Feedback, Comments & Corrections

SQLStringMBS.CopyBinaryData as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Copies the bytes from the internal buffer ignoring any text encoding.

Feedback, Comments & Corrections

SQLStringMBS.CopyText as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Copies the characters of this string as text.
Notes: Text encoding conversion may happen.

Feedback, Comments & Corrections

SQLStringMBS.Empty
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Forces a string to have 0 length.

Feedback, Comments & Corrections

SQLStringMBS.GetBinaryLength as UInt32
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns a count of the bytes in the binary data buffer.
This item is deprecated and should no longer be used. You can use BinaryLength instead.
Notes: Deprecated. Please use BinaryLength property.

Feedback, Comments & Corrections

SQLStringMBS.GetLength as UInt32
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Returns the number of characters in a SAString object.
This item is deprecated and should no longer be used. You can use Length instead.
Notes:
Deprecated. Please use Length property.
For multibyte character sets, GetLength counts each 8-bit character; that is, a lead and trail byte in one multibyte character are counted as two bytes.

Feedback, Comments & Corrections

SQLStringMBS.Left(count as Integer) as SQLStringMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Extracts the left part of a string.

Feedback, Comments & Corrections

SQLStringMBS.MakeLower
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Changes all characters in the string to lower case.

Feedback, Comments & Corrections

SQLStringMBS.MakeUpper
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Changes all characters in the string to upper case.

Feedback, Comments & Corrections

SQLStringMBS.Mid(first as Integer) as SQLStringMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Extracts the middle part of a string.
Notes: first: The zero-based index of the first character in this string object that is to be included in the extracted substring.

See also:

Feedback, Comments & Corrections

SQLStringMBS.Mid(first as Integer, Count as Integer) as SQLStringMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Extracts the middle part of a string.
Notes:
first: The zero-based index of the first character in this string object that is to be included in the extracted substring.
count: The number of characters to extract from this string object. If this parameter is not supplied, then the remainder of the string is extracted.

See also:

Feedback, Comments & Corrections

SQLStringMBS.Operator_Convert as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 14.0 Yes Yes Yes Yes No
Function: Convert operation for assignment to string.

See also:

Feedback, Comments & Corrections

SQLStringMBS.Operator_Convert(text as string)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 14.0 Yes Yes Yes Yes No
Function: Convert operation for assigning text string.

See also:

Feedback, Comments & Corrections

SQLStringMBS.Right(count as Integer) as SQLStringMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Extracts the right part of a string.

Feedback, Comments & Corrections

SQLStringMBS.TrimLeft
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Trim leading whitespace characters from the string.

Feedback, Comments & Corrections

SQLStringMBS.TrimRight
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Trim trailing whitespace characters from the string.

Feedback, Comments & Corrections

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




Links
MBS Xojo tutorial videos