This is a migrated thread and some comments may be shown as answers.

SQLITE null fields, strange problem

1 Answer 66 Views
General Discussion
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Steve
Top achievements
Rank 1
Steve asked on 17 Dec 2013, 07:02 PM
Hi,

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

Thanks,

1 Answer, 1 is accepted

Sort by
0
Zdravko
Telerik team
answered on 20 Dec 2013, 12:42 PM
Hello,

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.

Regards,
Zdravko
Telerik
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.
Tags
General Discussion
Asked by
Steve
Top achievements
Rank 1
Answers by
Zdravko
Telerik team
Share this question
or