openDatabase is a javascript/html5 function that allows for client local database storage
Questions tagged [opendatabase]
42 questions
0
votes
1 answer
Can PhoneGap apps use server pages to load on it?
I am trying to do web apps using PhoneGap framework for iOS. I need to know whether PhoneGap loads page from server or not, I mean , can I use server side scripting language like php, pyhon, etc?
And if I used those scripting language, can I use…
regeint
- 888
- 2
- 17
- 38
0
votes
1 answer
My developer app problem with opening database on Android 9
Can you help my?
I have created and published the app on Google play store that contains a database, I have tested it on different android phones. My app works perfect on android version (Android 10,8,5 etc...) except on Android 9, do you know how…
Milo91
- 1
0
votes
2 answers
SQLite plugin doesn't work Ionic - Apache Cordova
I am developing an Apache Cordova app for Android and IOS using Ionic framework too, for this I need to have a little database in local storage and I wan't to use SQLite. I follow a lot of tutorials and in fact this is very easy -at least it seems-,…
MadDev
- 113
- 16
0
votes
1 answer
Database statement is not working in google chrome
I am running chrome 43.0. In console i am running below command:
>> var db1 = openDatabase('testDB', '', 'my first database', 2 * 1024 * 1024, function(d){console.log(d);});
>> undefined
>> db1.transaction(function (tx) {
…
Pallavi Prasad
- 577
- 2
- 9
- 28
0
votes
1 answer
Altering db file is causing SQLiteDatabase.openDatabase() to crash
I have a normal opening of a database file, it works perfectly fine when opening a blank db file with only the metadata table, but as soon as I make another table, it causes the app to crash. Maybe it's different version db files? Please comment if…
Andrew Tsay
- 1,893
- 6
- 23
- 35
0
votes
1 answer
Phonegap - Assemble with a query result from another query - Sqlite Query
I can not make a selection via the result of the first
Goal is:
Do the query on the table "line" pick up your ID and search customers that line the "customer" table
This is my code:
db = window.openDatabase("test", "1.0", "Test DB", 1000000);…
Tigger
- 3
- 2
0
votes
2 answers
openDatabase Hello World - 2
This is a continuation from a previous stackoverflow question.
I've renamed some variables so that I can tell what are keywords and what are names that I can control.
Q: Why is the deleteRow function not working?
html5…</div>
<div class="grid ai-start jc-space-between fw-wrap">
<div class="grid gs4 fw-wrap tags ">
<a href="../../questions/tagged/javascript" class="post-tag grid--cell" title="show questions tagged 'javascript'" rel="tag">javascript</a>
<a href="../../questions/tagged/jquery" class="post-tag grid--cell" title="show questions tagged 'jquery'" rel="tag">jquery</a>
<a href="../../questions/tagged/opendatabase" class="post-tag grid--cell" title="show questions tagged 'opendatabase'" rel="tag">opendatabase</a>
</div>
<div class="started mt0">
<div class="s-user-card s-user-card">
<time class="s-user-card--time" datetime="asked Mar 26 '10 at 20:19">asked Mar 26 '10 at 20:19</time>
<a href="../../users/111665/phillip-senn" class="s-avatar s-avatar__32 s-user-card--avatar">
<img class="s-avatar--image" src="../../users/profiles/111665.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Phillip Senn" />
</a>
<div class="s-user-card--info">
<a href="../../users/111665/phillip-senn" class="s-user-card--link">Phillip Senn</a>
<ul class="s-user-card--awards">
<li class="s-user-card--rep" title="reputation score">46,771</li>
<li class="s-award-bling s-award-bling__gold" title="90 gold badges">90</li>
<li class="s-award-bling s-award-bling__silver" title="257 silver badges">257</li>
<li class="s-award-bling s-award-bling__bronze" title="373 bronze badges">373</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="mln24">
<div class="question-summary" id="question-summary-21983322">
<div class="statscontainer">
<div class="stats">
<div class="vote">
<div class="votes">
<span class="vote-count-post"><strong>0</strong></span>
<div class="viewcount">votes</div>
</div>
</div>
<div class="status ">
<strong>0</strong> answers
</div>
</div>
</div>
<div class="summary">
<h3><a href="../../questions/21983322/open-database-synchronously-in-javascript" class="question-hyperlink">Open Database Synchronously in JavaScript</a></h3>
<div class="excerpt">Trying to open a database synchronously using JavaScript. My code looks something like this. Whenever I run it on Chrome, I get the following 2 errors
Uncaught SecurityError: Failed to construct 'Worker': Script at…</div>
<div class="grid ai-start jc-space-between fw-wrap">
<div class="grid gs4 fw-wrap tags ">
<a href="../../questions/tagged/javascript" class="post-tag grid--cell" title="show questions tagged 'javascript'" rel="tag">javascript</a>
<a href="../../questions/tagged/synchronous" class="post-tag grid--cell" title="show questions tagged 'synchronous'" rel="tag">synchronous</a>
<a href="../../questions/tagged/opendatabase" class="post-tag grid--cell" title="show questions tagged 'opendatabase'" rel="tag">opendatabase</a>
</div>
<div class="started mt0">
<div class="s-user-card s-user-card">
<time class="s-user-card--time" datetime="asked Feb 24 '14 at 09:13">asked Feb 24 '14 at 09:13</time>
<a href="../../users/3297575/user3297575" class="s-avatar s-avatar__32 s-user-card--avatar">
<img class="s-avatar--image" src="../../users/profiles/3297575.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="user3297575" />
</a>
<div class="s-user-card--info">
<a href="../../users/3297575/user3297575" class="s-user-card--link">user3297575</a>
<ul class="s-user-card--awards">
<li class="s-user-card--rep" title="reputation score">13</li>
<li class="s-award-bling s-award-bling__bronze" title="2 bronze badges">2</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="mln24">
<div class="question-summary" id="question-summary-20509110">
<div class="statscontainer">
<div class="stats">
<div class="vote">
<div class="votes">
<span class="vote-count-post"><strong>0</strong></span>
<div class="viewcount">votes</div>
</div>
</div>
<div class="status ">
<strong>2</strong> answers
</div>
</div>
</div>
<div class="summary">
<h3><a href="../../questions/20509110/phonegap-storage-passing-variables-to-db-transaction-sql-lite" class="question-hyperlink">PhoneGap storage, Passing Variables to db.transaction, SQL Lite</a></h3>
<div class="excerpt">I'm working with the PhoneGap Open Database API. According to this documentation values should be inserted into an existing table using the follow code
function populateDB(tx) {
tx.executeSql('DROP TABLE IF EXISTS DEMO');
…</div>
<div class="grid ai-start jc-space-between fw-wrap">
<div class="grid gs4 fw-wrap tags ">
<a href="../../questions/tagged/ios" class="post-tag grid--cell" title="show questions tagged 'ios'" rel="tag">ios</a>
<a href="../../questions/tagged/sqlite" class="post-tag grid--cell" title="show questions tagged 'sqlite'" rel="tag">sqlite</a>
<a href="../../questions/tagged/cordova" class="post-tag grid--cell" title="show questions tagged 'cordova'" rel="tag">cordova</a>
<a href="../../questions/tagged/opendatabase" class="post-tag grid--cell" title="show questions tagged 'opendatabase'" rel="tag">opendatabase</a>
</div>
<div class="started mt0">
<div class="s-user-card s-user-card">
<time class="s-user-card--time" datetime="asked Dec 11 '13 at 01:54">asked Dec 11 '13 at 01:54</time>
<a href="../../users/996035/ben-pearce" class="s-avatar s-avatar__32 s-user-card--avatar">
<img class="s-avatar--image" src="../../users/profiles/996035.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Ben Pearce" />
</a>
<div class="s-user-card--info">
<a href="../../users/996035/ben-pearce" class="s-user-card--link">Ben Pearce</a>
<ul class="s-user-card--awards">
<li class="s-user-card--rep" title="reputation score">6,884</li>
<li class="s-award-bling s-award-bling__gold" title="18 gold badges">18</li>
<li class="s-award-bling s-award-bling__silver" title="70 silver badges">70</li>
<li class="s-award-bling s-award-bling__bronze" title="127 bronze badges">127</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="mln24">
<div class="question-summary" id="question-summary-14681256">
<div class="statscontainer">
<div class="stats">
<div class="vote">
<div class="votes">
<span class="vote-count-post"><strong>0</strong></span>
<div class="viewcount">votes</div>
</div>
</div>
<div class="status ">
<strong>0</strong> answers
</div>
</div>
</div>
<div class="summary">
<h3><a href="../../questions/14681256/setting-enable-universal-access-from-file-uris-for-webkit-in-tidesdk" class="question-hyperlink">Setting enable-universal-access-from-file-uris for Webkit in TideSDK?</a></h3>
<div class="excerpt">Can I set enable-universal-access-from-file-uris=true for Webkit in TideSDK ? Accessing openDatabase from TideSDK causes SECURITY_ERR: DOM Exception 18 error.
</div>
<div class="grid ai-start jc-space-between fw-wrap">
<div class="grid gs4 fw-wrap tags ">
<a href="../../questions/tagged/webkit" class="post-tag grid--cell" title="show questions tagged 'webkit'" rel="tag">webkit</a>
<a href="../../questions/tagged/tidesdk" class="post-tag grid--cell" title="show questions tagged 'tidesdk'" rel="tag">tidesdk</a>
<a href="../../questions/tagged/opendatabase" class="post-tag grid--cell" title="show questions tagged 'opendatabase'" rel="tag">opendatabase</a>
</div>
<div class="started mt0">
<div class="s-user-card s-user-card">
<time class="s-user-card--time" datetime="asked Feb 04 '13 at 06:09">asked Feb 04 '13 at 06:09</time>
<a href="../../users/1899630/sudip-saha" class="s-avatar s-avatar__32 s-user-card--avatar">
<img class="s-avatar--image" src="../../users/profiles/1899630.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Sudip Saha" />
</a>
<div class="s-user-card--info">
<a href="../../users/1899630/sudip-saha" class="s-user-card--link">Sudip Saha</a>
<ul class="s-user-card--awards">
<li class="s-user-card--rep" title="reputation score">300</li>
<li class="s-award-bling s-award-bling__gold" title="2 gold badges">2</li>
<li class="s-award-bling s-award-bling__silver" title="6 silver badges">6</li>
<li class="s-award-bling s-award-bling__bronze" title="21 bronze badges">21</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="mln24">
<div class="question-summary" id="question-summary-13089357">
<div class="statscontainer">
<div class="stats">
<div class="vote">
<div class="votes">
<span class="vote-count-post"><strong>0</strong></span>
<div class="viewcount">votes</div>
</div>
</div>
<div class="status answered-accepted">
<strong>1</strong> answer
</div>
</div>
</div>
<div class="summary">
<h3><a href="../../questions/13089357/phonegap-not-picking-up-transaction-function" class="question-hyperlink">Phonegap not picking up transaction function</a></h3>
<div class="excerpt">I am working with a opendatabase with phonegap and everything works fine in Chrome browser on my desktop but when I run it on my android device and click to the button that call insertRecord() it says not with eclipse I get error
10-26 10:37:13.191:…</div>
<div class="grid ai-start jc-space-between fw-wrap">
<div class="grid gs4 fw-wrap tags ">
<a href="../../questions/tagged/javascript" class="post-tag grid--cell" title="show questions tagged 'javascript'" rel="tag">javascript</a>
<a href="../../questions/tagged/android" class="post-tag grid--cell" title="show questions tagged 'android'" rel="tag">android</a>
<a href="../../questions/tagged/sqlite" class="post-tag grid--cell" title="show questions tagged 'sqlite'" rel="tag">sqlite</a>
<a href="../../questions/tagged/cordova" class="post-tag grid--cell" title="show questions tagged 'cordova'" rel="tag">cordova</a>
<a href="../../questions/tagged/opendatabase" class="post-tag grid--cell" title="show questions tagged 'opendatabase'" rel="tag">opendatabase</a>
</div>
<div class="started mt0">
<div class="s-user-card s-user-card">
<time class="s-user-card--time" datetime="asked Oct 26 '12 at 14:57">asked Oct 26 '12 at 14:57</time>
<a href="../../users/895953/skwidgets" class="s-avatar s-avatar__32 s-user-card--avatar">
<img class="s-avatar--image" src="../../users/profiles/895953.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="skwidgets" />
</a>
<div class="s-user-card--info">
<a href="../../users/895953/skwidgets" class="s-user-card--link">skwidgets</a>
<ul class="s-user-card--awards">
<li class="s-user-card--rep" title="reputation score">281</li>
<li class="s-award-bling s-award-bling__gold" title="2 gold badges">2</li>
<li class="s-award-bling s-award-bling__silver" title="8 silver badges">8</li>
<li class="s-award-bling s-award-bling__bronze" title="23 bronze badges">23</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="mln24">
<div class="question-summary" id="question-summary-10456686">
<div class="statscontainer">
<div class="stats">
<div class="vote">
<div class="votes">
<span class="vote-count-post"><strong>-1</strong></span>
<div class="viewcount">votes</div>
</div>
</div>
<div class="status ">
<strong>2</strong> answers
</div>
</div>
</div>
<div class="summary">
<h3><a href="../../questions/10456686/android-sqlite-do-i-have-to-create-and-replace-the-database-before-accessing-i" class="question-hyperlink">Android & sqlite - Do I have to create and replace the database before accessing it? or can I just open the db and query?</a></h3>
<div class="excerpt">I am starting to learn android development using the Eclipse SDK with SQLite.
If I have an existing database, which I created manually, in another application etc.
It seems as if all the examples, even the ones which bring in an existing database,…</div>
<div class="grid ai-start jc-space-between fw-wrap">
<div class="grid gs4 fw-wrap tags ">
<a href="../../questions/tagged/android" class="post-tag grid--cell" title="show questions tagged 'android'" rel="tag">android</a>
<a href="../../questions/tagged/sql" class="post-tag grid--cell" title="show questions tagged 'sql'" rel="tag">sql</a>
<a href="../../questions/tagged/sqlite" class="post-tag grid--cell" title="show questions tagged 'sqlite'" rel="tag">sqlite</a>
<a href="../../questions/tagged/opendatabase" class="post-tag grid--cell" title="show questions tagged 'opendatabase'" rel="tag">opendatabase</a>
</div>
<div class="started mt0">
<div class="s-user-card s-user-card">
<time class="s-user-card--time" datetime="asked May 04 '12 at 22:02">asked May 04 '12 at 22:02</time>
<a href="../../users/1375987/acesario" class="s-avatar s-avatar__32 s-user-card--avatar">
<img class="s-avatar--image" src="../../users/profiles/1375987.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="ACesario" />
</a>
<div class="s-user-card--info">
<a href="../../users/1375987/acesario" class="s-user-card--link">ACesario</a>
<ul class="s-user-card--awards">
<li class="s-user-card--rep" title="reputation score">89</li>
<li class="s-award-bling s-award-bling__bronze" title="9 bronze badges">9</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="s-pagination pager fr">
<a class="s-pagination--item" href="../../questions/tagged/opendatabase_page=2" rel="prev" title="Go to page 2">Prev </a>
<a class="s-pagination--item" href="../../questions/tagged/opendatabase_page=1" rel="" title="Go to page 1">1</a>
<a class="s-pagination--item" href="../../questions/tagged/opendatabase_page=2" rel="" title="Go to page 2">2</a>
<div class="s-pagination--item is-selected">3</div>
</div>
</div>
</div>
</div>
</div>
<script src="../../static/js/stack-icons.js"></script>
<script src="../../static/js/fromnow.js"></script>
</body>
</html>