I also ran into issues with the cursor and the expandable lists, so I get the cursor from the db, then load it into a 2-dimensional string array, and use that for the expandable list adapter. Clunky but it works.
On Jul 12, 2:01 pm, Beth <[email protected]> wrote: > Thanks Mark, content values work great. I am hoping for a few more > examples or some direction from the experts today. > > I want to get sqlite data into an expandable list view (activity). > After combing through the user groups and looking at docs and sample > code, I find nothing that shows a SimpleCursorTreeAdapter for ELV > holding data from sqlite. It looks like this adapter is intended for > use with the OTHER cursor, the one holding data returned from a > content provider query. Should I be using a different adapter for > sqlite data? If so, which one? > > Thanks in advance for any advice. > Best regards, > Beth > > On Jul 10, 4:08 pm, Mark Murphy <[email protected]> wrote: > > > > > Beth Mezias wrote: > > > Hello, > > > Can I get an (Android) example for getting signed numbers into a SQL > > > Lite database? I've been trying many silly things that generate syntax > > > errors so I thought I could put out the question. Note that I searched > > > and searched the groups and (surprisingly) found no history. > > > Outside of Android, here's a sqlite3 session: > > > SQLite version 3.6.10 > > Enter ".help" for instructions > > Enter SQL statements terminated with a ";" > > sqlite> create table foo (numberreal); > > sqlite> .schema foo > > CREATE TABLE foo (numberreal); > > sqlite> insert into foo (number) values (-1); > > sqlite> select * from foo; > > -1.0 > > sqlite> .exit > > > Inside of Android, you should be able to just put anegativenumberinto > > your ContentValues that you supply to your insert() call with > > SQLiteDatabase. > > > Can you provide any source code and the syntax errors you are getting? > > > -- > > Mark Murphy (a Commons > > Guy)http://commonsware.com|http://twitter.com/commonsguy > > > Android Development Wiki:http://wiki.andmob.org --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Beginners" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-beginners?hl=en -~----------~----~----~----~------~----~------~--~---
