Hello Thomas,
I never used LocalStorage directly from QML/JS. I access the database from the
C++ part. Your code looks like if you are using database transaction/commit.
But in C++ for me it did not work to set the PRAGMA if it is part of a
database transaction. I have to execute it on its own,
Oh, maximum sorry! I missed your proposed changes, which btw result in
the following (non?-)error:
Error: not an error Unable to execute multiple statements at a time
Cheers,
Thomas
On 24.08.2016 16:03, David Greaves wrote:
> Did you try?
>
> I combined both the
> PRAGMA foreign_keys = ON;
> a
Did you try?
I combined both the
PRAGMA foreign_keys = ON;
and
PRAGMA foreign_keys;
into one transaction.
David
On 24/08/16 14:56, TE wrote:
Sorry for being ambiguous. It returns: {"foreign_keys":0}
On 24.08.2016 15:53, David Greaves wrote:
What does
function queryForeignKeysEnabled()
{
Sorry for being ambiguous. It returns: {"foreign_keys":0}
On 24.08.2016 15:53, David Greaves wrote:
> What does
>
> function queryForeignKeysEnabled()
> {
> instance().transaction(function(tx) {
> var rs = tx.executeSql("PRAGMA foreign_keys = ON; PRAGMA
> foreign_keys;");
>
What does
function queryForeignKeysEnabled()
{
instance().transaction(function(tx) {
var rs = tx.executeSql("PRAGMA foreign_keys = ON; PRAGMA
foreign_keys;");
console.log(JSON.stringify(rs.rows.item(0)))
});
}
return?
David
On 24/08/16 13:45, TE wrote:
Hello M
Hello Matthias,
thanks for the quick reply! I access the database from the QML/JS
domain. To open a connection I use the following function:
function instance()
{
var db = Storage.LocalStorage.openDatabaseSync("Db", "", "Nodes",
500); /* DB Size: 5MB */
db.transaction(function(tx) {
Hello Thomas,
for me foreign key support is working. Directly after establishing the
connection to the SQLite database (QSqlDatabase::open()) I use QSqlQuery to
execute "PRAGMA foreign_keys = ON".
I think you have to do it every time you open a closed database, so I
implemented it in my databa
Hello fellow devs,
I have two SQLite tables. The second table references a key from the
first table as foreign key. Now when I delete a row in the first table I
want all rows from the second table referencing the deleted key to be
deleted as well. For this the action ON DELETE CASCADE seems to be
