Xojo Conferences
XDCMay2019MiamiUSA

Platforms to show: All Mac Windows Linux Cross-Platform

Next items

SQLValueMBS.Constructor(DataType 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: Creates a new empty value object with the given data type.

Feedback, Comments & Corrections

SQLValueMBS.setAsBlob(data as MemoryBlock)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 16.4 Yes Yes Yes Yes No
Function: Sets parameter's value as BLob data using a memoryblock.

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsBlob(data as SQLDataProviderMBS, BlockSize 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: Sets parameter's value as BLob data (SQLString)
Notes:
When you call the SQLCommandMBS.Execute method all input parameters are bound with their values, including Long and BLob(CLob) parameters.
That is the time when the data provider Read event runs to get the values in the block size you specify.

The default value for the block size is 0. If you use the default value, SQLAPI++ Library will automatically use the most appropriate size for current DBMS.

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsBlob(data 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: Sets parameter's value as BLob data (SQLString)

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsBlob(data 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: Sets parameter's value as BLob data (SQLString)
Example:
dim c as SQLCommandMBS // your command object
dim JPEGData as string // some data

c.Param("imageData").setAsBlob JPEGData

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsBlob(file as folderItem)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 16.4 Yes Yes Yes Yes No
Function: Sets field with content of file.
Example:
dim cmd as SQLCommandMBS // your command object

// pass folderitem to BLOB field
dim f as FolderItem = SpecialFolder.Desktop.Child("test.jpg")
cmd.Param("image").setAsBlob(f)
Notes:
The file will be read later when statement is executed.
May not work when using preemptive threads.

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsBlob(stream as Readable)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 16.4 Yes Yes Yes Yes No
Function: Sets field with content of stream.
Example:
dim cmd as SQLCommandMBS // your command object

// pass BinaryStream to BLOB field
dim f as FolderItem = SpecialFolder.Desktop.Child("test.jpg")
dim b as BinaryStream = BinaryStream.open(f)
cmd.Param("image").setAsBlob(b)
Notes:
The stream will be read later when statement is executed.
May not work when using preemptive threads.

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsBool(value as boolean)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Sets parameter's value as bool data.

Feedback, Comments & Corrections

SQLValueMBS.setAsBytes(data as MemoryBlock)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 16.4 Yes Yes Yes Yes No
Function: Sets parameter's value as binary data from memoryblock.

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsBytes(data 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: Set the value to be bytes with content of given string.
Notes:
For BLOB fields or parameters.
Same as the other variant, but avoids creating extra SQLStringMBS object.

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsBytes(value as SQLBytesMBS)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 16.1 Yes Yes Yes Yes No
Function: Set the value to be bytes with content of given Bytes object.
Notes:
For BLOB fields or parameters.
Same as the other variant, but avoids creating extra SQLStringMBS object.

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsBytes(value 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: Sets parameter's value as binary string data (SQLString).

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsClob(data as MemoryBlock)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 16.4 Yes Yes Yes Yes No
Function: Private method.
Notes: This method should make sure you don't accidentally a memoryblock instead of a text.

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsClob(data as SQLDataProviderMBS, BlockSize 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: Sets parameter's value as CLob data (SQLString)
Notes:
nWhen you call the SQLCommandMBS.Execute method all input parameters are bound with their values, including Long and BLob(CLob) parameters.
That is the time when the data provider Read event runs to get the values in the block size you specify.

The default value for the block size is 0. If you use the default value, SQLAPI++ Library will automatically use the most appropriate size for current DBMS.

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsClob(file as folderItem)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 16.4 Yes Yes Yes Yes No
Function: Sets field with content of file.
Notes:
The file will be read later when statement is executed.
May not work when using preemptive threads.

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsClob(stream as Readable)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 16.4 Yes Yes Yes Yes No
Function: Sets field with content of stream.
Notes:
The stream will be read later when statement is executed.
May not work when using preemptive threads.

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsClob(text 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: Sets parameter's value as CLob data (SQLString)

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsClob(text 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: Sets parameter's value as CLob data (SQLString)

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsDate(value as date)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 11.2 Yes Yes Yes Yes No
Function: Sets parameter's value with a date.
Example:
dim cmd as SQLCommandMBS // your command object
dim d as new date(2012,12,24,16,0,0) // some date
cmd.Param(3).setAsDate(d) // set third parameter
Notes: Same as setAsDateTime, but here we take a date object to make it more convenient.

Feedback, Comments & Corrections

SQLValueMBS.setAsDateTime(value as SQLDateTimeMBS)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Sets parameter's value as SQLDateTime data.

Feedback, Comments & Corrections

SQLValueMBS.setAsDefault
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Forces to use the default parameter's value.
Notes:
Forces DBMS API to use the default parameter value as the input value for an input or input/output parameter in a procedure.

If DBMS API does not support the concept of "default parameter values" in stored procedures, this setting will be ignored.

If you set this flag for the parameter that doesn't have a default value, the effect is DBMS defined (e.g. an error can be returned or NULL can be bound).

To cancel using the default parameter value you should call any other SQLValue::setAs... method to bind a parameter value.

To check whether this flag is set or not use isDefault method.

Feedback, Comments & Corrections

SQLValueMBS.setAsDouble(value as Double)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Sets parameter's value as Double data.

Feedback, Comments & Corrections

SQLValueMBS.setAsInterval(value as SQLIntervalMBS)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Sets an interval value.

Feedback, Comments & Corrections

SQLValueMBS.setAsLong(value as Int32)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Sets parameter's value as long data.

Feedback, Comments & Corrections

SQLValueMBS.setAsLongBinary(data as MemoryBlock)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 16.4 Yes Yes Yes Yes No
Function: Sets parameter's value as long binary data from memoryblock.

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsLongBinary(data as SQLDataProviderMBS, BlockSize 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: Sets parameter's value as long binary data (SQLString)
Notes:
When you call the SQLCommandMBS.Execute method all input parameters are bound with their values, including Long and BLob(CLob) parameters.
That is the time when the data provider Read event runs to get the values in the block size you specify.

The default value for the block size is 0. If you use the default value, SQLAPI++ Library will automatically use the most appropriate size for current DBMS.

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsLongBinary(data 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: Sets parameter's value as long binary data (SQLString)

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsLongBinary(data 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: Sets parameter's value as long binary data (SQLString)

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsLongBinary(file as folderItem)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 16.4 Yes Yes Yes Yes No
Function: Sets field with content of file.
Notes:
The file will be read later when statement is executed.
May not work when using preemptive threads.

See also:

Feedback, Comments & Corrections

Next items

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




Links
MBS Xojo blog