marcucio/Cordova-WP-SqlitePlugin

Database issue

Opened this issue · 9 comments

vishvendu commented

var db = window.sqlitePlugin.openDatabase(" database", "1.0", "issue",200000);
or
var db = sqlitePlugin.openDatabase("database ", "1.0", "issue",200000);

Tried both but not able to insert the values in database (Window 8 platform).

Please help me out.

Thanks.

biodiv commented

Try to use a callback function. Your syntax will on all devices I tried fail for WP8 - it works with Android/iOS though.

var db = sqlitePlugin.openDatabase("database", "1.0", "database", -1, function () {

    if (db) {
        db.transaction(function(tx){
            tx.executeSql(...);
        });
    }
    else {
        console.log("database error");
    }
});
vishvendu commented

This is not working for window 8....and i guess this plugin support windows 8 platform ??

biodiv commented

This Plugin is for Windows Phone 8. It only works with Phonegap 2.7 or lower.

marcucio commented

I have a solution for Windows 8 too but it needs to be cleaned up before I put it on github. Hopefully I will have time to circle back around to update this plugin after I complete this other big project I am working on.

On Sep 26, 2013, at 9:28 AM, biodiv notifications@github.com wrote:

This Plugin is for Windows Phone 8. It only works with Phonegap 2.7 or lower.

—
Reply to this email directly or view it on GitHub.

vishvendu commented

I'm using phonegap 2.2.0 for WP8 hope it works.

vishvendu commented

And is there any DLL i need to require for this plugin ??

biodiv commented

Yes, you need to include community.csharp.sqlite as a reference. The file is included in the package.

mhd3000 commented

I didn't find community.csharp.sqlite..

marcucio commented

https://github.com/marcucio/Cordova-WP-SqlitePlugin/tree/master/Community.CsharpSqlite.WinPhone

On Sep 29, 2013, at 3:32 AM, mhd3000 notifications@github.com wrote:

I didn't find community.csharp.sqlite..

—
Reply to this email directly or view it on GitHub.