Platforms to show: All Mac Windows Linux Cross-Platform
SQLDataProviderMBS class
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| class | SQL | MBS SQL Plugin | 9.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Use this to set a blob/clob object with streaming data. For example if you want to add a 1 GB big file to the database without loading it into RAM in one piece, you can use this class to read it in small chunks.
- event Read(byref PieceType as Integer, Length as UInt32) as string
- 4 constants
Constants
| Constant | Value | Description |
|---|---|---|
| kFirstPiece | 1 |
One of the piece type constants.
The first piece is processed. You may setup everything you need to handle the data. |
| kLastPiece | 3 |
One of the piece type constants.
The last piece is processed. You can close files/network connections. |
| kNextPiece | 2 |
One of the piece type constants.
The next piece is processed. Not the first one or the last one, but one between. |
| kOnePiece | 4 |
One of the piece type constants.
The whole data stream is delivered in one call of the event. |
This class has no sub classes.
Some methods using this class:
- SQLBLobMBS.Constructor(dataProvider as SQLDataProviderMBS, BlockSize as UInt32)
- SQLCLobMBS.Constructor(dataProvider as SQLDataProviderMBS, BlockSize as UInt32)
- SQLLongBinaryMBS.Constructor(dataProvider as SQLDataProviderMBS, BlockSize as UInt32)
- SQLLongCharMBS.Constructor(dataProvider as SQLDataProviderMBS, BlockSize as UInt32)
- SQLValueMBS.setAsBlob(data as SQLDataProviderMBS, BlockSize as UInt32)
- SQLValueMBS.setAsClob(data as SQLDataProviderMBS, BlockSize as UInt32)
- SQLValueMBS.setAsLongBinary(data as SQLDataProviderMBS, BlockSize as UInt32)
- SQLValueMBS.setAsLongChar(data as SQLDataProviderMBS, BlockSize as UInt32)
Some examples using this class:
Blog Entries
Xojo Developer Magazine
The items on this page are in the following plugins: MBS SQL Plugin.
SQLDataConsumerMBS - SQLDateTimeMBS
