Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    Carson Huang
    @kot09
    OKay thanks.
    Carson Huang
    @kot09
    @brodybits Is tehre some work being done for DELETE on windows? If no, what is the issue? I would like to help out.
    Christopher J. Brody
    @brodybits
    A patch would be great. Try to run it against the spec test suite (and enable the tests for windows platform). Also close is not really implemented, which is a prerequisite to do delete correctly (and again test).
    Thanks for your interest!
    Carson Huang
    @kot09
    Is there a limit to the db file?
    Christopher J. Brody
    @brodybits
    Not for Android or iOS. If Windows imposes a limit I think it would be extremely high.
    Carson Huang
    @kot09
    Okay thanks. Also, is DROP available on Windows?
    Christopher J. Brody
    @brodybits
    Yes if you use the Cordova windows target (which will work on Windows Phone 8.1). No if you use wp8.
    If you use wp8, the plugin simulates DROP by simply deleting all rows from the table.
    Carson Huang
    @kot09
    I'm trying to make an app for my Surface
    What if it's just W8?
    Christopher J. Brody
    @brodybits
    The "windows" platform works on Windows 8, Windows 8.1, and Windows Phone 8.1 so it should work
    Carson Huang
    @kot09
    @brodybits Is there a success callback when I use a CREATE table query?
    Okay, nevermind, I think I found a way to make it work. Thanks!
    Christopher J. Brody
    @brodybits
    Good to hear.
    Carson Huang
    @kot09
    In a executeSql(), the arguments possible are (sql, values, callbackSuccess, callbackError), correct?
    Christopher J. Brody
    @brodybits
    Yes
    Carson Huang
    @kot09
    For some reason, the callbackError does not have the message attribute
    {"db":{"openargs":{"name":"my.db","dblocation":"docs"},"dbname":"my.db"},"txlock":true,"readOnly":false,"executes":[]} is what it returns
    Christopher J. Brody
    @brodybits
    It would help if you can try to make a small test program that demonstrates this issue and raise a bug report. Please make sure you specify which platform, very important
    Carson Huang
    @kot09
    My situation right now is I'm trying to create a table with columns. Do you think that might be the cause?
    161 columns&=*
    Christopher J. Brody
    @brodybits
    Should not be
    By default build configuration maximum is 2000 columns!
    Carson Huang
    @kot09
    Okay, never, error was on my side... I had two ID columns.
    never mind*
    I feel like an idiot haha. Spent a good hour testing things out, trying to figure what was wrong.
    Christopher J. Brody
    @brodybits
    No problem, glad you fixed it.
    Carson Huang
    @kot09
    What are the data types available? I'm trying to add a float data type.
    Christopher J. Brody
    @brodybits
    Check out: https://www.sqlite.org/datatype3.html
    NULL, INTEGER, REAL, TEXT, BLOB
    You may want to read the section about sqlite type affinity as well at: https://www.sqlite.org/datatype3.html#affinity
    Sigfrido Rodríguez Santos
    @identy
    :)
    laoyao
    @laoyao
    execute a sql in a transation
    can only run one time
    Why
    there is no response on second time
    @brodybits Can you help me
    laoyao
    @laoyao
    db.transaction(function(tx) {
    tx.executeSql("select distinct contractor_name from construction_range;", [], function(tx, res) {
    alert(JSON.stringify(res));
    }, function(e) {
    alert("ERROR: " + e.message);
    });
    });
    Christopher J. Brody
    @brodybits
    Hi. Unfortunately I do not really understanding your problem.
    Christopher J. Brody
    @brodybits
    That looks very strange. It would help to know how you create and populated the table and also which platform you see this on
    I can look at this issue sometime next week.
    laoyao
    @laoyao
    @brodybits hi
    are you on line?
    Christopher J. Brody
    @brodybits
    One moment
    What is going on?
    Adrienrx
    @adrienrx
    Can i create this function in my sqlite database ?
    http://www.thismuchiknow.co.uk/?p=71
    Christopher J. Brody
    @brodybits
    You could add user-defined functions to the Objective-C code for iOS, https://github.com/liteglue/Android-sqlite-native-driver for Android, or the embedded SQLite3-WinRT library for Windows/Windows Phone 8.1. To get user defined functions working in Javascript would be extremely difficult (if possible at all) since it is an asynchronous interface.
    laoyao
    @laoyao
    Is there some people on line