Xojo Conferences
MBSSep2018MunichDE
XDCMay2019MiamiUSA

Platforms to show: All Mac Windows Linux Cross-Platform

SQLPreparedStatementMBS.kTypeBlob = 14
Type Topic Plugin Version
const SQL MBS SQL Plugin 11.2
Function: One of the data type constants.
Notes: Binary large Object. Pass a string or memoryblock.

Feedback, Comments & Corrections

SQLPreparedStatementMBS.kTypeBool = 1
Type Topic Plugin Version
const SQL MBS SQL Plugin 11.2
Function: One of the data type constants.
Notes: Boolean

Feedback, Comments & Corrections

SQLPreparedStatementMBS.kTypeBytes = 11
Type Topic Plugin Version
const SQL MBS SQL Plugin 11.2
Function: One of the data type constants.
Notes:
a binary string.
(which is a string without text encoding)

Feedback, Comments & Corrections

SQLPreparedStatementMBS.kTypeClob = 15
Type Topic Plugin Version
const SQL MBS SQL Plugin 11.2
Function: One of the data type constants.
Notes: Character Large Object

Feedback, Comments & Corrections

SQLPreparedStatementMBS.kTypeDateTime = 8
Type Topic Plugin Version
const SQL MBS SQL Plugin 11.2
Function: One of the data type constants.
Notes: Date and/or Time.

Feedback, Comments & Corrections

SQLPreparedStatementMBS.kTypeDouble = 6
Type Topic Plugin Version
const SQL MBS SQL Plugin 11.2
Function: One of the data type constants.
Notes: double float value.

Feedback, Comments & Corrections

SQLPreparedStatementMBS.kTypeInterval = 9
Type Topic Plugin Version
const SQL MBS SQL Plugin 13.5
Function: One of the data type constants.
Notes:
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.

Feedback, Comments & Corrections

SQLPreparedStatementMBS.kTypeLong = 4
Type Topic Plugin Version
const SQL MBS SQL Plugin 11.2
Function: One of the data type constants.
Notes: signed 32 bit integer

Feedback, Comments & Corrections

SQLPreparedStatementMBS.kTypeLongBinary = 12
Type Topic Plugin Version
const SQL MBS SQL Plugin 11.2
Function: One of the data type constants.
Notes: Long binary.

Feedback, Comments & Corrections

SQLPreparedStatementMBS.kTypeLongChar = 13
Type Topic Plugin Version
const SQL MBS SQL Plugin 11.2
Function: One of the data type constants.
Notes: Long string.

Feedback, Comments & Corrections

SQLPreparedStatementMBS.kTypeNull = 99
Type Topic Plugin Version
const SQL MBS SQL Plugin 14.3
Function: One of the data type constants.
Notes: NULL value

Feedback, Comments & Corrections

SQLPreparedStatementMBS.kTypeNumeric = 7
Type Topic Plugin Version
const SQL MBS SQL Plugin 13.5
Function: One of the data type constants.
Notes:
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.

Feedback, Comments & Corrections

SQLPreparedStatementMBS.kTypeShort = 2
Type Topic Plugin Version
const SQL MBS SQL Plugin 11.2
Function: One of the data type constants.
Notes: signed 16 bit integer

Feedback, Comments & Corrections

SQLPreparedStatementMBS.kTypeString = 10
Type Topic Plugin Version
const SQL MBS SQL Plugin 11.2
Function: One of the data type constants.
Notes: String

Feedback, Comments & Corrections

SQLPreparedStatementMBS.kTypeULong = 5
Type Topic Plugin Version
const SQL MBS SQL Plugin 11.2
Function: One of the data type constants.
Notes: unsigned 32 bit integer

Feedback, Comments & Corrections

SQLPreparedStatementMBS.kTypeUnknown = 0
Type Topic Plugin Version
const SQL MBS SQL Plugin 11.2
Function: One of the data type constants.
Notes: unknown type

Feedback, Comments & Corrections

SQLPreparedStatementMBS.kTypeUShort = 3
Type Topic Plugin Version
const SQL MBS SQL Plugin 11.2
Function: One of the data type constants.
Notes: unsigned 16 bit integer

Feedback, Comments & Corrections

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





Links
MBS FileMaker blog