Platforms to show: All Mac Windows Linux Cross-Platform
SQLDataConsumerMBS class
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| class | SQL | MBS SQL Plugin | 9.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
If you query a clob/blob value, that value may not fit into memory, so you may prefer to get a callback for data and write it to a file in small chunks.
- event Write(PieceType as Integer, data as string, Length as UInt32, BlobSize as UInt32)
- 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:
- SQLFieldMBS.ReadLongOrLob(toConsumer as SQLDataConsumerMBS, BlockSize as Integer)
- SQLParamMBS.ReadLongOrLob(toConsumer as SQLDataConsumerMBS, BlockSize as Integer)
Some examples using this class:
Blog Entries
Xojo Developer Magazine
The items on this page are in the following plugins: MBS SQL Plugin.
SQLDatabaseMBS - SQLDataProviderMBS
