On Dec 22, 12:38 pm, jcknight <[email protected]> wrote:
> I have a SimpleCursorAdapter that I’m using to pull the contents of 
> aSQLitetable 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
> );

Try escaping the quotes in the String literal in your code:
"dayOfWeek varchar(128) default \'\',"

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

Reply via email to