SQLITE null fields, strange problem

2 posts, 0 answers
  1. Steve
    Steve avatar
    7 posts
    Member since:
    Oct 2013

    Posted 17 Dec 2013 Link to this post


    I have an app that is undergoing beta testing and we've got a strange issue. This is a one off and can't seem to be recreated.

    A record was inserted into a table with a set primary key value, say 704, along with some other values. The insert was successful as it then performed the onSuccess callback.    

    When I do SELECT * FROM table WHERE ID = 704,  i get the entire row as null entries, including the id column which was originally set to 704 but this column too returns as null.    

    Am i missing something?  besides wanting to know how the values got set to null, how can the id column be null if it is used in the WHERE statement of the SELECT query???

    Any help GREATLY appreciated

  2. Zdravko
    Zdravko avatar
    657 posts

    Posted 20 Dec 2013 Link to this post


    You can check what is going on with your table in debug mode. Here is a screenshot of the Resources window and WebSql section where you should check.

    Any questions regarding SQLite plugin using you should directly address to plugin developers.

    You've missed the Icenium Visual Studio Integration keynote? It has been recorded and posted here.
    Looking for tips & tricks directly from the Icenium team? Check out our blog!
    Share feedback and vote for features on our Feedback Portal.
Back to Top