Xojo Developer Conference
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.

Platforms to show: All Mac Windows Linux Cross-Platform

SQLParamMBS.Option(name as string) as string
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
property SQL MBS SQL Plugin 9.3 Yes Yes Yes Yes No
Function: The string value of a specific parameter option.
Notes:
see also:
http://www.sqlapi.com/OnLineDoc/Param_Option.html
(Read and Write computed property)

Feedback, Comments & Corrections

SQLParamMBS.ReadLongOrLob(toConsumer as SQLDataConsumerMBS, BlockSize 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: The Long or Lob data reading mode.
Notes:
SQLAPI++ Library provides two ways to read Long or BLob(CLob) object's value (usually SQLField or SQLParam objects):

1. reading of Long or Lob data at once into an internal buffer (like ordinary string or binary values);
2. piecewise reading of Long or Lob data using user defined callback.
kLongOrLobReaderDefault reading mode used by default.

If you want to control piecewise reading of Long or BLob(CLob) data you should set LongOrLobReaderMode and use kLongOrLobReaderManual reading mode for Long or BLob(CLob) parameters or fields you want to process with your data consumer. After that each fetch will skip reading Long and BLob(CLob) parameters that you set to be read manually. To read field or parameter defined to be read manually you should call ReadLongOrLob method for each of them after the fetch. ReadLongOrLob method will repeatedly call the data consumer Write event.

See also:

Feedback, Comments & Corrections

SQLParamMBS.ReadLongOrLob(toFile 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: Starts reading of Long or BLob(CLob) value to the given file.
Example:
dim cmd as SQLCommandMBS // your command
dim f as FolderItem = SpecialFolder.Desktop.Child("test.jpg")
dim Param as SQLParamMBS = cmd.Param("image")
// read blob content to binarystream
Param.ReadLongOrLob(f)
Notes: May raise IOExceptions if things go wrong.

See also:

Feedback, Comments & Corrections

SQLParamMBS.ReadLongOrLob(toStream as Writeable)
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 16.4 Yes Yes Yes Yes No
Function: Starts reading of Long or BLob(CLob) value to the given writeable stream.
Example:
dim cmd as SQLCommandMBS // your command
dim f as FolderItem = SpecialFolder.Desktop.Child("test.jpg")
dim b as BinaryStream = BinaryStream.Create(f, true)
dim param as SQLParamMBS = cmd.param("image")
// read blob content to binarystream
param.ReadLongOrLob(b)
Notes: This allows you to read in chunks the data to a stream, e.g. binarystream, textoutputstream or socket.

See also:

Feedback, Comments & Corrections

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




Links
MBS FileMaker blog