Online Documentation - Statistics - FAQ - Plugin Parts (All, Dependencies) - Class hierarchy
New in Version 22.2 22.3 22.4 22.5 23.0 23.1 23.2 23.3 23.4 23.5 24.0 24.1
The list of the topics, classes, interfaces, controls, modules, global methods by category, global methods by name, screenshots, licenses and examples.
Platforms to show: All Mac Windows Linux Cross-Platform
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
class | SQL | MBS SQL Plugin | 11.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
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.
Constant | Value | Description |
---|---|---|
kTypeBlob | 16 |
Binary large Object. Pass a string or memoryblock. |
kTypeBool | 1 |
Boolean |
kTypeBytes | 13 | a binary string or MemoryBlock. more |
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. more |
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). more |
kTypeShort | 2 |
signed 16 bit integer |
kTypeString | 12 | String. more |
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.
1 interfaces.
The items on this page are in the following plugins: MBS SQL Plugin.