DatabaseRecord

super: Object

A DatabaseRecord is a data structure that represent values to be used within the addRecord or updateRecord methods.

Events

Load() This event is called when the object becames available in the current runtime system.
Unload() This event is called when the object has been removed from the current runtime system (but not yet deallocated).

Methods

func bindNull(name: String) Bind null value.
func bindText(name: String, value: String) Bind String value.
func bindBool(name: String, value: Bool) Bind Bool value.
func bindInt(name: String, value: Int) Bind Int value.
func bindInt64(name: String, value: Int) Bind Int64 value.
func bindDouble(name: String, value: Float) Bind Double value.
func bindData(name: String, value: Data) Bind Data value.

Examples

This example assumes that you have a valid connection with a Database. That DB database object should contain an images table (id int column as primary key and a data column as BLOB):

// INSERT EXAMPLE

// extract PNG data from and Image
var image = image1.PNGRepresentation();

// prepare database record
var rec = DatabaseRecord();
rec.bindInt("id", 1);
rec.bindData("data", image);

// insert record into table images
DB.addRecord(rec, "images");
if (DB.isError) Console.write(DB.errorMessage);

// UPDATE EXAMPLE

// extract PNG data from and Image
var image = image1.PNGRepresentation();

// prepare database record
var rec = DatabaseRecord();
rec.bindInt("id", 1);
rec.bindData("data", image);

// update record into table images WHERE id=1
DB.updateRecord(rec, "images", "id=1");
if (DB.isError) Console.write(DB.errorMessage);