Platforms to show: All Mac Windows Linux Cross-Platform

SQLPreparedStatementMBS class

Type Topic Plugin Version macOS Windows Linux iOS Targets
class SQL MBS SQL Plugin 11.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: The class for prepared statements if you work with SQLDatabaseMBS class.
Notes:
If you work with SQLCommandMBS class, you can set parameters there directly.

For the SQL string you number parameters with colon and number. Like this: :1, :2, :3.
This is an abstract class. You can't create an instance, but you can get one from various plugin functions.
  • 4 properties
  • 19 methods
    • method Bind(name As String, value as Variant)
    • method Bind(name As String, value as Variant, type as Integer)
    • method Bind(Values as Dictionary)
    • method Bind(values() as Variant)
    • method Bind(zeroBasedIndex as Integer, value as Variant)
    • method Bind(zeroBasedIndex as Integer, value as Variant, type as Integer)
    • method BindType(name As String, type as Integer)
    • method BindType(types() as Integer)
    • method BindType(zeroBasedIndex as Integer, type as Integer)
    • method Clear
    • method Constructor   Private
    • method ExecuteSQL(ParamArray bindItems As Variant)
    • method ExecuteSQLMT(ParamArray bindItems As Variant)
    • method SelectSQL(ParamArray bindItems As Variant) As RowSet
    • method SelectSQLMT(ParamArray bindItems As Variant) As Rowset
    • method SQLExecute(ParamArray bindItems as Variant)
    • method SQLExecuteMT(ParamArray bindItems as Variant)
    • method SQLSelect(ParamArray bindItems as Variant) As RecordSet
    • method SQLSelectMT(ParamArray bindItems as Variant) As RecordSet
  • 21 constants

Data Type Constants

Constant Value Description
kTypeBlob 16 Binary large Object. Pass a string or memoryblock.
kTypeBool 1 Boolean
kTypeBytes 13 a binary string or MemoryBlock.
(which is a string without text encoding)

This is usually a varbinary field. kTypeLongBinary is used for bigger binary data and streamed. And kTypeBlob is used for huge streams of bytes and also transferred in chunks. In most data base systems the varchar field is stored within the record, while BLOB and CLOB are stored separately.
kTypeClob 17 Character Large Object.
kTypeDateTime 10 Date and/or Time.
kTypeDouble 8 double float value.
kTypeInt32 4 signed 32 bit integer
kTypeInt64 6 Signed 64-bit integer.
kTypeInterval 11 An interval.
Please pass SQLIntervalMBS in the variant. If the variant contains anything else, the plugin will pass nil value.

When passing variant for value, MemoryBlock and Strings without text encoding are converted to byte values (BLOB). Texts and Strings with encoding are converted to text values. Other types are translated as good as possible. Raises exceptions if you pass anything which is not recognized.
kTypeLong 4 signed 32 bit integer
kTypeLongBinary 14 Long binary.
kTypeLongChar 15 Long string.
kTypeNull 99 NULL value
kTypeNumeric 9 A number (Int64 or double).
This can be used for Int64 or Double values. Depending of the type of number in the variant, the plugin will either make an Int64 or a double internally.

When passing variant for value, MemoryBlock and Strings without text encoding are converted to byte values (BLOB). Texts and Strings with encoding are converted to text values. Other types are translated as good as possible. Raises exceptions if you pass anything which is not recognized.
kTypeShort 2 signed 16 bit integer
kTypeString 12 String.
This is usually a varchar field. kTypeLongChar is used for bigger varchars and streamed. And kTypeClob is used for huge streams of characters (BLOB for text) and also transferred in chunks. In most data base systems the varchar field is stored within the record, while BLOB and CLOB are stored separately.
kTypeUInt32 5 unsigned 32 bit integer
kTypeUInt64 7 Unsigned 64-bit integer.
kTypeULong 5 unsigned 32 bit integer
kTypeUnknown 0 unknown type
kTypeUShort 3 unsigned 16 bit integer

This class has no sub classes.

Interfaces:

1 interfaces.

Some methods using this class:

Some examples using this class:

Blog Entries

Xojo Developer Magazine

Videos


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


SQLPositionMBS   -   SQLStringMBS


💬 Ask a question or report a problem
The biggest plugin in space...