SQLite Plugin for Xojo

PreparedStatement.BindBlob Method (console safe)

Binds a Blob value for the prepared statement, using string to pass in the BLOB value.

BindBlob(
   fieldNumber as Integer,
   value as String)

Parameters

fieldNumber
The field number (1 based)
value
The value of the blob as string (can be string without encoding for Binary data for example)

Remarks

Note that if your blob is big then you may want to stream the blob, to do that you would use BindZeroBlob to reserver space for the BLOB and then you would use the OpenBlob function on the EinhugurSQLite.Database class.

See Also

PreparedStatement Class