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
    On iOS, adding the plugin using CLI works perfectly. It's just for the windows platform I'm having issues.
    Christopher J. Brody
    @brodybits
    Are you using Visual Studio to run the program or are you using Cordova CLI to run the program?
    Carson Huang
    @kot09
    I tried both.
    Christopher J. Brody
    @brodybits
    explicitly. In Visual Studio, there is a drop-down for it. When using Cordova CLI, there is an option (I forget which one)
    You have to specify which CPU architecture, i.e. x86/x86_64 (or x64, I forget which)/arm
    Carson Huang
    @kot09
    In CLI, I explicitly built it with x86
    I'll try it again, give me a second.
    Carson Huang
    @kot09
    @brodybits So I just took a clean copy of my project, added my other plugins + sqlite through CLI. When I build windows, I specifically mention x86 <cordova build windows – --archs="x86">. I then run it using <cordova run -- --windows>, and it gives me the following error: The processor architecture of your project 'neutral' doesn't match the processor architecture 'x86' of the referenced project 'SQLite3'. Change the targeted processor architectures to align between your project and its references.
    Carson Huang
    @kot09
    So I managed to run it. I just need to specify the archs in the run command as well : <cordova run -- --windows archs="x86">
    Christopher J. Brody
    @brodybits
    That ks
    Thanks for reporting this, it really needs to be documented somewhere. Maybe I will blog I sometime.
    Carson Huang
    @kot09
    @brodybits Is DELETE available on windows?
    Christopher J. Brody
    @brodybits
    Not yet
    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
    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