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 (number real); sqlite> .schema foo CREATE TABLE foo (number real); 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 a negative number into 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 -~----------~----~----~----~------~----~------~--~---
