Platforms to show: All Mac Windows Linux Cross-Platform

SQLiteFunctionMBS class   New in 24.1

// Create a custom function with a handler function:
Dim f As New SQLiteFunctionMBS
f.name = "SHA256"
f.ArgumentCount = 1
f.Flags = f.kFlagDeterministic OR f.kFlagUTF8 OR f.kFlagInnocuous
// Text encoding UTF8, function is deterministic and can be cached, function is innocuous as it depends only on parameters
AddHandler f.Perform, AddressOf PerformSHA256
functions.Append f // keep reference

• event Perform(ArgumentCount as Integer, Arguments() as Variant)
• 6 properties
  • property ArgumentCount as Integer
  • property CallCounter as Integer
  • property DatabaseCount as Integer
  • property Enabled as Boolean
  • property Flags as Integer
  • property Name as String
• 12 methods
  • method Constructor
  • method Destructor
  • method ResultBlob(data as MemoryBlock)
  • method ResultBlob(data as ptr, size as Integer)
  • method ResultBlob(text as string)
  • method ResultDouble(value as Double)
  • method ResultError(ErrorMessage as string)
  • method ResultErrorCode(ErrorCode as Integer)
  • method ResultInteger(value as Integer)
  • method ResultNull
  • method ResultText(text as string)
  • method ResultZeroBlob(Length as Integer)
• 4 constants

Flags

This class has no sub classes.

Some examples using this class:

• /SQL/SQLDatabaseMBS SQLite custom function
• /SQL/Xojo SQLite custom function

Blog Entries

• 15th birthday of MBS SQL Plugin
• News from the MBS Xojo Plugins Version 24.1
• MonkeyBread Software Releases the MBS Xojo Plugins in version 24.1
• Did you know that you can load extensions in SQLite?
• MBS Xojo Plugins, version 24.1pr1

Release notes

• Version 24.1
  • Added SQLiteFunctionMBS class to add custom SQLite functions for SQLite database connections.

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

SQLite3MBS   -   SQLLongBinaryMBS