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 -~----------~----~----~----~------~----~------~--~---
