Hi,

did u use Cursor.setNotificationUri(...) before closing the database
in the query function of the provider.??

On Jun 19, 5:40 am, Jawon <[email protected]> wrote:
> I have a ContentProvider that stores data in a SQLite database. I also
> have an app with a ListView that displays data queried from the
> ContentProvider. I run a query() on the ContentProvider, then I take
> the returned Cursor, make an adaptor, and set it to the ListView, like
> so:
>
>                 dbAdapter = getContentResolver();
>                 deviceList = (ListView)this.findViewById(R.id.deviceList);
>
>                 Cursor allDevices =
>                         dbAdapter.query(BluetoothContentProvider.CONTENT_URI,
>                                                         
> BluetoothContentProvider.ALL_COLUMNS,
>                                                         null,
>                                                         null,
>                                                         
> BluetoothContentProvider.KEY_ROWID + " ASC");
>                 startManagingCursor(allDevices);
>                 SimpleCursorAdapter cursorAdaptor =
>                         new SimpleCursorAdapter(this, R.layout.device, 
> allDevices,
> COLUMN_HEADINGS, DISPLAY_FIELDS);
>                 deviceList.setAdapter(cursorAdaptor);
>
> If I close the database inside the query() of the Provider, I get an
> "Invalid statement in fillWindow()" error from the returned Cursor,
> but I don't want to leave the database permanently open either. What
> should I do?

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