Stack Overflow
Stack Overflow

Questions tagged [opendatabase]

openDatabase is a javascript/html5 function that allows for client local database storage

42 questions
2
votes
1 answer

how to fix flutter sqflite opendatabase error?

bi user, i success running using database with sqflite in iOS, but i got problem in android.. DBHelper code : import 'package:path_provider/path_provider.dart'; import 'package:sqflite/sqflite.dart'; import…
killer whale
  • 397
  • 2
  • 8
  • 15
2
votes
1 answer

"Cannot read property 'message' of undefined" in WebSQL error callback

My code: function onSuccess(transaction, resultSet) { console.log('Query completed: ' + JSON.stringify(resultSet)); } function onError(transaction, err) { console.log("Error : " + err.message); } function createTBinventorymastercatalogue(tx)…
Johanna Cristine Dy
  • 493
  • 7
  • 17
2
votes
0 answers

Sencha+ cordova + WP8 : SQL proxy issue, openDatabase is undefined

I am trying to integrate a sencha app on windows phone 8 using cordova. This Sencha app uses a store with SQL proxy. On running this app on device, I get an error: "openDatabase is undefined". If I remove the SQL proxy, I see no errors and the app…
rituraj346
  • 23
  • 4
2
votes
3 answers

Error processing SQL: TypeError: window.openDatabase is not a function

I have some strange issue in my code. i have create simple DB_Function.js to manage JS function inside html page. i am calling function inside so first that will initialize the DB and create table if needed. Issue is here…
Chintan Khetiya
  • 15,962
  • 9
  • 47
  • 85
2
votes
2 answers

NullPointerException in ContextWrapper.openOrCreateDatabase when using SQLiteOpenHelper

I'm making a new android application that uses databases. I used similar code to create and copy database, but it's not working for some reason. I can't figure it out, help. LogCat: 07-03 21:38:54.260: E/AndroidRuntime(12172): FATAL EXCEPTION:…
user1816780
  • 121
  • 4
  • 14
1
vote
2 answers

Local Storage or similar on Blackberry OS < 6.0

I am trying to find a solution for a web app that will be able to operate offline. I am fine with iOS and Android and Blackberry OS 6.0 and greater as all these support localStorage. I can get certain Blackberrys below OS 0.6 to store information…
Andy Charrington
  • 21
  • 2
1
vote
1 answer

SQLite - database is locked in "PRAGMA journal_mode" - error only for certain Android devices

Google Play pre-launch report found an issue with my app. This issue comes up only for a few devices. The problem occurs when I try to open the app for the first time, and the SQLite database is being opened for the first time (after it was copied…
ZP007
  • 582
  • 7
  • 12
1
vote
1 answer

How to add/subtract a day

How can I subtract (or add) days from a dateandtime or smalldatetime date in Web SQL? I have tried searching for it, but couldn't find anything. The solutions that exist are all for SQL and MySQL. I have tried: DATEADD (SQL), and DATE_ADD/DATE_SUB…
user3001859
  • 265
  • 1
  • 3
  • 13
1
vote
1 answer

Hardware-only 'Undefined' database error on openDatabase in Cordova 2.5 on Android - only for first attempt

Just updated my android app to Cordova 2.5 and, although it works beautifully in the emulator, it has developed a problem on my HTC desire such that I get a 'undefined' databse error when I try db = window.openDatabase("ProblemDirectoryDB", "1.0",…
theotherdy
  • 715
  • 1
  • 7
  • 22
1
vote
1 answer

openDatabase stuck

I have a project with Blackberry Web Work, and this is my first time for mobile programming. I want to create cache database using window.openDatabase But something is strange, I put alert after to show this database, but it didnot show anything. I…
user1471392
  • 11
  • 2
1
vote
2 answers

Test if local database (websql) contains desired new fields, and add them if not

I'm building a crossplatform HTML/Javascript app for iOS and Android using PhoneGap and jQueryMobile, and I am upgrading my app with (among others) a few new fields in one table of the local database (localdatabase/websql). The challenge I want to…
Wytze
  • 7,844
  • 8
  • 49
  • 62
0
votes
1 answer

Trouble with functions in javascript

I'm trying to figure out local caching for a project I'm working on right now and while I've had success with setting up, populating and doing most of the db side, my javascript seems to be freaking out on me. I've made a jsfiddle (…
Twomz
  • 702
  • 10
  • 27
0
votes
0 answers

Why react native sqlite typescript opendatabase keep return error "TypeError: Cannot convert null value to object"

I already put the database file in the path \android\app\src\main\assets\www but the openDatabase() always return this error "Error opening database: [TypeError: Cannot convert null value to object]" Inside the class object class SQLiteWrapper { …
DeveloperAcc Appslause
  • 1
  • 1
0
votes
1 answer

Features of openDatabase

I am looking at building an application that stores data locally using openDatabase. I have a few questions about it. Can the database been accessed any other way about from the website? I assume using something like firebug I could make queries…
Diver Dan
  • 9,953
  • 22
  • 95
  • 166
0
votes
1 answer

openDatabase error: Cannot convert null value to object

I'm using react-native-sqlite-storage, wanted to use JSON Functions And Operators and after reading the issues I found that I need to use the Android native SQLite #480. Then I changed the react-native.config.js in order to use SQLite bundled with…
Jony
  • 51
  • 9
1
2
3