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
The class for a data provider.

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.

Blog Entries

Xojo Developer Magazine

Some methods using this class:

Some examples using this class:

Some related classes:


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


SQLDataConsumerMBS   -   SQLDateTimeMBS


The biggest plugin in space...