I have a SimpleCursorAdapter that I’m using to pull the contents of a SQLite table and populate a ListView. Here is some code:
http://pastie.org/private/ibrwbcv1xu1dpv2l7ys5g When it tries to populate the ListView I get an IllegalArgument exception: 12-22 09:03:16.423: ERROR/AndroidRuntime(230): java.lang.IllegalArgumentException: column 'active' does not exist So it's complaining about the column "active" not existing. However when I connect to the emulator via adb and list the table's schema, I get this: CREATE TABLE backup_schedules ( _id integer primary key autoincrement, name varchar(128) not null, interval integer not null, active integer not null default 1, location integer not null, dayOfWeek varchar(128) default '', day integer not null, hour integer not null, minute integer not null ); To me that looks like the field is there. If I take out the reference to the "active" column in the SimpleCursorAdapter (so it just pulls the _id and name fields) then it doesn't throw an exception and the ListView works just fine. Actually, if I try to use any field that is defined after "name" it throws the same exception. This lead me to believe I have an error in my SQL definition, but I can't find one and there is no complaint when I create the table, either manually or through the adapter. The SimpleCursorAdapter fields and onCreate() method that makes the table are included in the code link above. -- You received this message because you are subscribed to the Google Groups "Android Developers" 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-developers?hl=en
