PreparedStatement.Bind Method (console safe)
Binds a double value for the prepared statement.
Bind(
fieldNumber
as Integer,
value
as Double)
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