Difference between revisions of "SQLBindStr"
From SCAR Divi Manual
(Created page with "==Definition== <source lang="scar" lines="false"> procedure SQLBindStr(const QueryIndex, ParamIndex: Integer; const Str: string); </source> ==Availability== SCAR Divi 3.31 > Cur...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 54: | Line 54: | ||
==See Also== | ==See Also== | ||
*[[SQLBindInt]] | *[[SQLBindInt]] | ||
| + | *[[SQLBindInt64]] | ||
| + | *[[SQLBindByte]] | ||
| + | *[[SQLBindBool]] | ||
*[[SQLQueryEx]] | *[[SQLQueryEx]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:Database Functions]] | [[Category:Database Functions]] | ||
Latest revision as of 10:28, 14 February 2012
Definition
procedure SQLBindStr(const QueryIndex, ParamIndex: Integer; const Str: string);
Availability
SCAR Divi 3.31 > Current
Description
Binds a string parameter Str to an SQLite3 query statement given by QueryIndex at the parameter index given by ParamIndex. A parameter is specified in your query by "?" and the index is offset at 1 rather than 0.
Example
var
DB, Query, InsertID: Integer;
begin
DB := SQLOpen(WorkspacePath + 'test.db3', True);
try
// Create a table
SQLQuery(DB, 'CREATE TABLE IF NOT EXISTS test(id INTEGER PRIMARY KEY, string TEXT)');
// Insert 2 rows into the table
Query := SQLQueryEx(DB, 'INSERT INTO test VALUES(NULL, ?)');
try
SQLBindStr(Query, 1, 'Hello Mars!');
SQLQueryStep(Query);
SQLQueryReset(Query);
SQLBindStr(Query, 1, 'Hello World!');
SQLQueryStep(Query);
InsertID := SQLLastID(DB);
finally
SQLQueryFree(Query);
end;
// Get the data stored in the last row
Query := SQLQueryEx(DB, 'SELECT * FROM test WHERE id = ?');
try
SQLBindInt(Query, 1, InsertID);
if SQLQueryStep(Query) = SQL_ROW then
WriteLn(SQLColumnStr(Query, 1));
finally
SQLQueryFree(Query);
end;
finally
SQLFree(DB);
end;
end.Output:
Hello World!
