Difference between revisions of "SQLFree"
From SCAR Divi Manual
| (2 intermediate revisions by the same user not shown) | |||
| Line 8: | Line 8: | ||
==Description== | ==Description== | ||
| − | Frees an open [ | + | Frees an open [[SQLite3]] database connection specified by the index '''DBIndex'''. The function returns [[true]] if the index was found in the system and the database connection freed. |
==Example== | ==Example== | ||
| Line 57: | Line 57: | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| − | [[Category:Database Functions | + | [[Category:Database Functions]] |
Latest revision as of 10:02, 10 February 2012
Definition
function SQLFree(const DBIndex: Integer): Boolean;
Availability
SCAR Divi 3.31 > Current
Description
Frees an open SQLite3 database connection specified by the index DBIndex. The function returns true if the index was found in the system and the database connection freed.
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!
