![]() ![]() Id = db. I am unable to insert tht values in to the table, the id is returning -1 that depicts that there is an error,while inserting the values. This is my SimpleDBAdapter Class that encapsulates all the complexities of accessing the database and the inner class SimpleDBHelper takes care of CRUD operations,now the Problem that i am facing here is when i deploy the code, the tables were getting created, but the View 2 Replies View Related Android :: Inserting Records In SQLite Aug 20, 2010 SELECT orderdate, SUM (COUNT (orderid)) OVER (ORDER BY orderdate rows between unbounded preceding and current row) as RunningTotal FROM table ORDER BY orderdate GROUP BY orderdate How do I do this in SQLite I've googled - and see many examples of either SUM or COUNT but seldom combined and never to achieve a running total of a count. when i test the application on 1.5 device it works good but when i try to run it on a 1.6 device i get a force close message with following logcat output:Ä 3-19 09:31:35.206: ERROR/AndroidRuntime(224): Uncaught handler: thread main exiting due to uncaught exception. I am developing this application on SDK 1.5. Hence the maximum number of tables in a schema cannot reach more than 2147483646. I am developing an application which uses sqlite db for storing records. A SQLite database can have maximum 2147483646 pages.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |