SQLite Plugin for Xojo

PreparedStatement.Bind Method (console safe)

Binds a String value for the prepared statement.

Bind(
   fieldNumber as Integer,
   value as String)

Parameters

fieldNumber
The field number (1 based)
value
The value to bind.

Remarks

Note that SQLite supports parameters without numbering or numbered in the SQL statement like for example:

insert into Team (Name, Coach, City) values (?1,?2,?2)


or without numbers:

>insert into Team (Name, Coach, City) values (?1,?2,?2)


or without numbers:


insert into Team (Name, Coach, City) values (?,?,?)


In the former example then you have chance to use same binding in more than one place in the SQL, while not in the later example.

See Also

PreparedStatement Class