Databases
StackOverflow2013
Postsdbo
POBlackberry Playbook - app in development hangs every second time it is run
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POBlackberry Playbook - app in development hangs every second time it is run
    primarykey
    data
    text
    <p>This is a fairly straightforward question for such odd behaviour, but that is exactly what my app is doing on the Playbook. I open the app the first time and it runs perfectly. I close the app, and then open it again and it hangs/freezes after the first action I perform with it. I then close the app, it seems to reset itself, and then opens and runs perfectly the next time.</p> <p>I am using the latest WebWorks and am debugging on the PB with a debug token. My previous app (written/tested on pre OS2.0) worked, and continues to work, just fine.</p> <p>I am pleased to post code if you would like, but it may be a waste of space. In an effort to root out the problem, I wrote a quick Hello World app that writes one item to an HTML5 database on the playbook (my main app also uses WebDB), and that app, as simple as it is, has exactly the same behavior. All my apps function fine in Chrome.</p> <p>If anyone has any thoughts about what could be causing this behaviour, please post a reply.</p> <p>HTML:</p> <pre><code>&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt; &lt;html xmlns="http://www.w3.org/1999/xhtml"&gt; &lt;head&gt; &lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8" /&gt; &lt;title&gt;Untitled Document&lt;/title&gt; &lt;script type="text/javascript" src="helloworld.js"&gt;&lt;/script&gt; &lt;/head&gt; &lt;body&gt; &lt;input type="text" id="testDBInput"/&gt; &lt;button type="button" onclick="testDB()"&gt;go&lt;/button&gt; &lt;/body&gt; &lt;/html&gt; </code></pre> <p>JavaScript Document:</p> <pre><code>var taskdb=openDatabase ("helloworldDB", "1.0", "test database", 10*1024*1024); taskdb.transaction(function(tx) { tx.executeSql("CREATE TABLE IF NOT EXISTS maintable (id integer primary key autoincrement, nametitle TEXT)"); }); function testDB() { var testTitle=document.getElementById("testDBInput").value; taskdb.transaction(function(tx) { tx.executeSql("INSERT INTO maintable (nametitle) VALUES (?)", [testTitle], function (tx, results) { }); }); } </code></pre> <p><code>blackberry-tablet.xml</code>:</p> <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt; &lt;qnx&gt; &lt;icon&gt; &lt;image&gt;&lt;/image&gt; &lt;/icon&gt; &lt;author&gt;***edited for privacy***&lt;/author&gt; &lt;authorId&gt;***edited for privacy***&lt;/authorId&gt; &lt;platformVersion&gt;1.0.0.0&lt;/platformVersion&gt; &lt;/qnx&gt; </code></pre> <p><code>config.xml</code>:</p> <pre><code>&lt;?xml version="1.0" encoding="utf-8"?&gt; &lt;widget xmlns=" http://www.w3.org/ns/widgets" xmlns:rim="http://www.blackberry.com/ns/widgets" version="1.0.0.0"&gt; &lt;name&gt;Tester&lt;/name&gt; &lt;description&gt; PB Tester &lt;/description&gt; &lt;rim:orientation mode="landscape"/&gt; &lt;rim:loadingScreen onFirstLaunch="true" &gt; &lt;/rim:loadingScreen&gt; &lt;author&gt;***edited for privacy***&lt;/author&gt; &lt;icon src="bdicon.png"/&gt; &lt;content src="index.html"/&gt; &lt;feature id="blackberry.app" required="true" version="1.0.0.0"/&gt; &lt;feature id="blackberry.ui.dialog" required="true" version="1.0.0.0"/&gt; &lt;/widget&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMichael Donohue
    1. USrobert smith
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POBlackberry Playbook - app in development hangs every second time it is run
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POBlackberry Playbook - app in development hangs every second time it is run
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI recommend posting your little example. It would probably be useful in its own right beyond debugging this problem.
      singulars
      1. POBlackberry Playbook - app in development hangs every second time it is run
      1. USsarnold
    2. CO@sarnold Fair enought request. I posted an update, but apparently didn't do a good job of spacing. It should still be readable.
      singulars
      1. POBlackberry Playbook - app in development hangs every second time it is run
      1. USrobert smith
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload