Xojo Conferences
XDCMay2019MiamiUSA

Platforms to show: All Mac Windows Linux Cross-Platform

Previous items

SQLValueMBS.setAsLongBinary(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.setAsLongChar(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.setAsLongChar(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 character 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.setAsLongChar(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.setAsLongChar(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.setAsLongChar(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 long character data (SQLString)

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsLongChar(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 long character data (SQLString)

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsNull
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: Sets value to null.

Feedback, Comments & Corrections

SQLValueMBS.setAsNumeric(value as SQLNumericMBS)
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 SQLNumeric data.

Feedback, Comments & Corrections

SQLValueMBS.setAsShort(value as Int16)
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 short data.

Feedback, Comments & Corrections

SQLValueMBS.setAsString(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.setAsString(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 character string data (SQLString)

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsString(value 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 character string data.
Notes: Same as setAsString, but for your convenience with a REALbasic string instead of a SQLStringMBS object.

See also:

Feedback, Comments & Corrections

SQLValueMBS.setAsText(value as text)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 15.2 Yes Yes Yes Yes No
Function: Sets the value using text value.
Notes: Available on Xojo 2015 and newer.

Feedback, Comments & Corrections

SQLValueMBS.setAsULong(value 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 unsigned long data.

Feedback, Comments & Corrections

SQLValueMBS.setAsUnknown
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 type as unknown.

Feedback, Comments & Corrections

SQLValueMBS.setAsUShort(value as UInt16)
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 unsigned short data.
Notes: Sets value as unsigned short data.

Feedback, Comments & Corrections

SQLValueMBS.setAsValueRead(value as SQLValueReadMBS)
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 from SQLParam or SQLField objects.
Notes: This method allows using SQLField or SQLParam object received from one SQL statement as a parameter for another SQL statement.

Feedback, Comments & Corrections

SQLValueMBS.setVariant(value as Variant)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 16.4 Yes Yes Yes Yes No
Function: Sets the value based on a variant.
Example:
dim con as SQLConnectionMBS // your connection
dim pic as picture // some picture

// get picture data
dim jpegData as MemoryBlock = pic.GetData(Picture.FormatJPEG, 80)

// get a command for an Insert command
dim sql as string = "Insert into BlobTest(name, image) values (:name, :image)"
dim cmd as new SQLCommandMBS(con, sql)

// set values by variant
cmd.Param("name").setVariant "logo.jpg"
cmd.Param("image").setVariant jpegData

// do the insert
cmd.Execute
Notes:
MemoryBlock and Strings without text encoding are converted to byte values (BLOB).
Texts and Strings with encoding are converted to text values.
Raises exceptions if you pass anything which is not recognized.
Other types are translated as good as possible.

Feedback, Comments & Corrections

Previous items

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




Links
MBS Xojo PDF Plugins