From Xojo Documentation

Revision as of 16:06, 14 February 2013 by PLefebvre (talk | contribs) (Created page with '<ShowIf version=2013r1> {{MethodBox | name=OpenBlob | owner=SQLiteDatabase | ownertype=class | scope=public | parameters=tableName As String, columnName As String, row As UIn…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
You are currently browsing the old Xojo documentation site. Please visit the new Xojo documentation site!


SQLiteDatabase.OpenBlob(tableName As String, columnName As String, row As UInt64, readWrite As Boolean, databaseName As String = "") As SQLiteBlob

Supported for all project types and targets.

Opens a BLOB column for the specified table and column at the specified row (rowID).


  • The row parameter is the rowid value, and not the actual row number, for example if you only have one record in your database, with a rowid of 100 then you would pass in a row of 100 and not 1 for example.
  • Pass in false as the readWrite parameter to open the blob for reading only.
  • The blob cannot be resized
  • Creating a new blob automatically zeros the entire blob
  • The row must exist when calling CreateBlob, it does not create a new record for you

See Also

SQLiteBlob, SQLiteDatabase.CreateBlob