SQLValueMBS.Constructor(DataType as Integer)

SQLValueMBS.setAsBlob(data as MemoryBlock)

See also:

• setAsBlob(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsBlob(data as SQLStringMBS)
• setAsBlob(data as string)
• setAsBlob(file as folderItem)
• setAsBlob(stream as Readable)

SQLValueMBS.setAsBlob(data as SQLDataProviderMBS, BlockSize as UInt32)

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:

• setAsBlob(data as MemoryBlock)
• setAsBlob(data as SQLStringMBS)
• setAsBlob(data as string)
• setAsBlob(file as folderItem)
• setAsBlob(stream as Readable)

SQLValueMBS.setAsBlob(data as SQLStringMBS)

See also:

• setAsBlob(data as MemoryBlock)
• setAsBlob(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsBlob(data as string)
• setAsBlob(file as folderItem)
• setAsBlob(stream as Readable)

SQLValueMBS.setAsBlob(data as string)

dim c as SQLCommandMBS // your command object
dim JPEGData as string // some data

c.Param("imageData").setAsBlob JPEGData

See also:

• setAsBlob(data as MemoryBlock)
• setAsBlob(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsBlob(data as SQLStringMBS)
• setAsBlob(file as folderItem)
• setAsBlob(stream as Readable)

SQLValueMBS.setAsBlob(file as folderItem)

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)

The file will be read later when statement is executed.
May not work when using preemptive threads.

See also:

• setAsBlob(data as MemoryBlock)
• setAsBlob(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsBlob(data as SQLStringMBS)
• setAsBlob(data as string)
• setAsBlob(stream as Readable)

SQLValueMBS.setAsBlob(stream as Readable)

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)

The stream will be read later when statement is executed.
May not work when using preemptive threads.

See also:

• setAsBlob(data as MemoryBlock)
• setAsBlob(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsBlob(data as SQLStringMBS)
• setAsBlob(data as string)
• setAsBlob(file as folderItem)

SQLValueMBS.setAsBool(value as boolean)

SQLValueMBS.setAsBytes(data as MemoryBlock)

See also:

• setAsBytes(data as string)
• setAsBytes(value as SQLBytesMBS)
• setAsBytes(value as SQLStringMBS)

SQLValueMBS.setAsBytes(data as string)

For BLOB fields or parameters.
Same as the other variant, but avoids creating extra SQLStringMBS object.

See also:

• setAsBytes(data as MemoryBlock)
• setAsBytes(value as SQLBytesMBS)
• setAsBytes(value as SQLStringMBS)

SQLValueMBS.setAsBytes(value as SQLBytesMBS)

For BLOB fields or parameters.
Same as the other variant, but avoids creating extra SQLStringMBS object.

See also:

• setAsBytes(data as MemoryBlock)
• setAsBytes(data as string)
• setAsBytes(value as SQLStringMBS)

SQLValueMBS.setAsBytes(value as SQLStringMBS)

See also:

• setAsBytes(data as MemoryBlock)
• setAsBytes(data as string)
• setAsBytes(value as SQLBytesMBS)

SQLValueMBS.setAsClob(data as MemoryBlock)   Private

This method should make sure you don't accidentally a memoryblock instead of a text.

See also:

• setAsClob(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsClob(file as folderItem)
• setAsClob(stream as Readable)
• setAsClob(text as SQLStringMBS)
• setAsClob(text as string)

SQLValueMBS.setAsClob(data as SQLDataProviderMBS, BlockSize as UInt32)

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:

• setAsClob(data as MemoryBlock)
• setAsClob(file as folderItem)
• setAsClob(stream as Readable)
• setAsClob(text as SQLStringMBS)
• setAsClob(text as string)

SQLValueMBS.setAsClob(file as folderItem)

The file will be read later when statement is executed.
May not work when using preemptive threads.

See also:

• setAsClob(data as MemoryBlock)
• setAsClob(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsClob(stream as Readable)
• setAsClob(text as SQLStringMBS)
• setAsClob(text as string)

SQLValueMBS.setAsClob(stream as Readable)

The stream will be read later when statement is executed.
May not work when using preemptive threads.

See also:

• setAsClob(data as MemoryBlock)
• setAsClob(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsClob(file as folderItem)
• setAsClob(text as SQLStringMBS)
• setAsClob(text as string)

SQLValueMBS.setAsClob(text as SQLStringMBS)

See also:

• setAsClob(data as MemoryBlock)
• setAsClob(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsClob(file as folderItem)
• setAsClob(stream as Readable)
• setAsClob(text as string)

SQLValueMBS.setAsClob(text as string)

See also:

• setAsClob(data as MemoryBlock)
• setAsClob(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsClob(file as folderItem)
• setAsClob(stream as Readable)
• setAsClob(text as SQLStringMBS)

SQLValueMBS.setAsDate(value as date)

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

Same as setAsDateTime, but here we take a date object to make it more convenient.

SQLValueMBS.setAsDateTime(value as dateTime)

Same as setAsDate, but here we take a dateTime object to make it more convenient.

See also:

• setAsDateTime(value as SQLDateTimeMBS)

SQLValueMBS.setAsDateTime(value as SQLDateTimeMBS)

See also:

• setAsDateTime(value as dateTime)

SQLValueMBS.setAsDefault

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.

SQLValueMBS.setAsDouble(value as Double)

SQLValueMBS.setAsInt32(value as Int32)

SQLValueMBS.setAsInt64(value as Int64)

SQLValueMBS.setAsInteger(value as Integer)

Int32 or Int64 depending whether app is 32 or 64 bit.

SQLValueMBS.setAsInterval(value as SQLIntervalMBS)

SQLValueMBS.setAsLong(value as Int32)

SQLValueMBS.setAsLongBinary(data as MemoryBlock)

See also:

• setAsLongBinary(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsLongBinary(data as SQLStringMBS)
• setAsLongBinary(data as string)
• setAsLongBinary(file as folderItem)
• setAsLongBinary(stream as Readable)

SQLValueMBS.setAsLongBinary(data as SQLDataProviderMBS, BlockSize as UInt32)

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:

• setAsLongBinary(data as MemoryBlock)
• setAsLongBinary(data as SQLStringMBS)
• setAsLongBinary(data as string)
• setAsLongBinary(file as folderItem)
• setAsLongBinary(stream as Readable)

SQLValueMBS.setAsLongBinary(data as SQLStringMBS)

See also:

• setAsLongBinary(data as MemoryBlock)
• setAsLongBinary(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsLongBinary(data as string)
• setAsLongBinary(file as folderItem)
• setAsLongBinary(stream as Readable)

SQLValueMBS.setAsLongBinary(data as string)

See also:

• setAsLongBinary(data as MemoryBlock)
• setAsLongBinary(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsLongBinary(data as SQLStringMBS)
• setAsLongBinary(file as folderItem)
• setAsLongBinary(stream as Readable)

SQLValueMBS.setAsLongBinary(file as folderItem)

The file will be read later when statement is executed.
May not work when using preemptive threads.

See also:

• setAsLongBinary(data as MemoryBlock)
• setAsLongBinary(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsLongBinary(data as SQLStringMBS)
• setAsLongBinary(data as string)
• setAsLongBinary(stream as Readable)

SQLValueMBS.setAsLongBinary(stream as Readable)

The stream will be read later when statement is executed.
May not work when using preemptive threads.

See also:

• setAsLongBinary(data as MemoryBlock)
• setAsLongBinary(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsLongBinary(data as SQLStringMBS)
• setAsLongBinary(data as string)
• setAsLongBinary(file as folderItem)

SQLValueMBS.setAsLongChar(data as MemoryBlock)   Private

This method should make sure you don't accidentally a memoryblock instead of a text.

See also:

• setAsLongChar(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsLongChar(file as folderItem)
• setAsLongChar(stream as Readable)
• setAsLongChar(text as SQLStringMBS)
• setAsLongChar(text as string)

SQLValueMBS.setAsLongChar(data as SQLDataProviderMBS, BlockSize as UInt32)

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:

• setAsLongChar(data as MemoryBlock)
• setAsLongChar(file as folderItem)
• setAsLongChar(stream as Readable)
• setAsLongChar(text as SQLStringMBS)
• setAsLongChar(text as string)

SQLValueMBS.setAsLongChar(file as folderItem)

The file will be read later when statement is executed.
May not work when using preemptive threads.

See also:

• setAsLongChar(data as MemoryBlock)
• setAsLongChar(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsLongChar(stream as Readable)
• setAsLongChar(text as SQLStringMBS)
• setAsLongChar(text as string)

SQLValueMBS.setAsLongChar(stream as Readable)

The stream will be read later when statement is executed.
May not work when using preemptive threads.

See also:

• setAsLongChar(data as MemoryBlock)
• setAsLongChar(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsLongChar(file as folderItem)
• setAsLongChar(text as SQLStringMBS)
• setAsLongChar(text as string)

SQLValueMBS.setAsLongChar(text as SQLStringMBS)

See also:

• setAsLongChar(data as MemoryBlock)
• setAsLongChar(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsLongChar(file as folderItem)
• setAsLongChar(stream as Readable)
• setAsLongChar(text as string)

SQLValueMBS.setAsLongChar(text as string)

See also:

• setAsLongChar(data as MemoryBlock)
• setAsLongChar(data as SQLDataProviderMBS, BlockSize as UInt32)
• setAsLongChar(file as folderItem)
• setAsLongChar(stream as Readable)
• setAsLongChar(text as SQLStringMBS)

SQLValueMBS.setAsNull

SQLValueMBS.setAsNumeric(value as SQLNumericMBS)

SQLValueMBS.setAsShort(value as Int16)

SQLValueMBS.setAsString(data as MemoryBlock)   Private

This method should make sure you don't accidentally a memoryblock instead of a text.

See also:

• setAsString(value as SQLStringMBS)
• setAsString(value as string)

SQLValueMBS.setAsString(value as SQLStringMBS)

See also:

• setAsString(data as MemoryBlock)
• setAsString(value as string)

SQLValueMBS.setAsString(value as string)

Same as setAsString, but for your convenience with a Xojo string instead of a SQLStringMBS object.

See also:

• setAsString(data as MemoryBlock)
• setAsString(value as SQLStringMBS)

SQLValueMBS.setAsUInt32(value as UInt32)

SQLValueMBS.setAsULong(value as UInt32)

SQLValueMBS.setAsUnknown