<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><span class="tlid-translation translation" lang="en">Hello,
again.<br>
<br>
I have the following problem with sqlite and gambas.<br>
I would like to use the functions of Foreign Key with sqlite and
gambas.<br>
The problem with this is that with Gambas the execute statement
"pragma foreign_keys = on" is unsuccessful. The "pragma
foreign_keys" statement always returns "0", ie no foreign key is
active.<br>
However, if I set the foreign key property at the shell level,
this will correctly return the "1" (at the shell level) as a
successful setting. If I use the same database at the same time
as this one on the shell level, however, I only get back the "0"
in Gambas, so no foreign key is active. Does Gambas have a
problem with the foreign key?<br>
So set foreign key on the shell level - no problem.<br>
Create foreign key within Gambas - not possible.<br>
I have already tested this with different sqlite versions higher
than 3.6 in the virtualbox with Lubuntu and Ubuntu. Always the
same result.<br>
How can I use Foreign Key with Gambas?<br>
For solutions and suggestions, I would be very grateful.</span></p>
<p><br>
<span class="tlid-translation translation" lang="en"><span
class="tlid-translation translation" lang="en">greetings</span></span></p>
<p><span class="tlid-translation translation" lang="en">Peter ......<br>
</span></p>
<p><span class="tlid-translation translation" lang="en"><br>
</span></p>
</body>
</html>