I want to create a table whose primary key will be some other field and not _id . The below table gets created but the value of _id remains null :
"create table accounts ("+BaseColumns._ID+" integer , profile_name text primary key" +" name text not null);";
My doubt is wont _id get auto incremented if we do not place "+BaseColumns._ID integer primary key autoincrement+" .
View 3 Replies
I am trying to pull data from a cursor which is initialized as follows:
Uri inboxUri = Uri.parse("content://sms/"); Cursor c = managedQuery(inboxUri, null, null, null, null);
This effectively gets me to latest text message that has been sent/ received. I am now trying to put certain fields into a listView, but need to format them before displaying them. The date is represented in the table in milliseconds and I want to convert it to a date before placing it in the list.
Here is where I am trying to place the date in my list. How can I format these fields before placing them into my listview?
CODE:.......................
I'm having problems with spinner. I'm using spinner that is bound to a SimpleCursorAdapter. I want to retrieve the text value of the selected item. So i tried
CODE:..................
I am trying to connect a AutoCompleteTextView with a SimpleCursorAdapter, which narrows down the selection of a list of words, when the user starts typing.
Following some other posts here, I've come up with the following code, but it doesn't work. I defined a FilterQueryProvider runQuery() method for the SimpleCursor Adapter, but when I use the debugger in the code, the response from the ContentResolver.query((0 method call is null.
I think the problem is that there is no relationship between the CONTENT_URI and the SQL database, but I can't be sure.
CODE:.......................
The favicon field returned by the browser bookmark provider is a sqlite blob. I want to display the bookmarks in a listview with the favicon but couldn't find a way to do it. I tried using a SimpleCursorAdapter.ViewBinder but I get an exception.
This is what my code looks like :
CODE:...................
I have an application that involves reading a text dictionary file with about 7000 entries, and allowing the user to choose one of these. My first approach was to allow the user to select one of these by using a AutoCompleteTextView together with ArrayAdapter<String>. This works, but is very slow (~10 seconds to update the word list each time the user enters a character to narrow down the choice).
I was wondering how to rework it so that I could use a database using a SimpleCursorAdapter instead. In other words, to hope that a SQL database could provide a more efficient ordering and access for the elements. Is this the best way to do it? I've also seen several references to SQLiteDatabase, but don't know which one to use.
I found this code fragmant consisting of an extended SimpleAdapter. http://sacoskun.blogspot.com/2008/08...leadapter.html<http://sacoskun.blogspot.com/2008/08/autocompletetextview-with-simple...>
Unfortunately, this is not a complete worked out example. Could someone forward me a more complete example? I've found lots of code fragments, but no code that shows how to initialise the SimpleCursorAdapter contents, or how it works together with the AutoCompleteTextView.
I have a problem with bindView() that has me puzzled. I am using it to customize each row, including setting icons, coloring the background and setting up listeners for buttons. It mostly works as expected, but not quite.
When I fill the ListView with SimpleCursorAdapter, I get multiple calls to bindView() for position 0, but only 1 call for the other rows. The problem is that when all is said and done, I have 2 rows (LinearLayout) created for position 0. Here is a sample log extract:
CODE:........
I use a view holder class to hold the view, position and other data so that when a button is clicked, I can retrieve the holder with view.getParent.getTag(). This all works fine. The problem is that there are two views for position 0, but it's the first one in the above logcat that seems to be displayed. My code which acts on the rows when a button is clicked (especially setting background color) does not reliably hit the position 0 row that is actually displayed.
I can see what's happening but I am at a loss about what to do about it. Why are two view created for position 0? Is it something that I can control? How? If not, how should I deal with it so that the results when I modify the views are predictable?
If I pass a cursor to a simplecursoradapter, do I still need to close the cursor? if so when: after I pass it to the adapter or when the adapter is finished?
View 2 Replies View RelatedSince the query that comprises my ListView basically gets the rowID, name, and a third column from my databases's table, I want to be able to filter the cursor based on the partial value of the name column. However, I am uncertain of whether I can do this directly from runQuery without expanding my DB class since I want to filter the existing cursor, or will I have to create a new query function in my DB class that partially searches my name column, and if so, how would I go about creating the query statement while using the CharSequence constraint argument in runQuery?I am also concerned about the performance issues associated with trying to run multiple queries based on partial text since the DB table in question has about 1300-1400 rows. In other words, would I run into a bottleneck trying to filter the cursor?
View 1 Replies View RelatedThe problem is as follows: - My app is deriving from TabActivity that has 3 tabs - Each tab has a ListView - Tab1 is populated by an adapter that inherit SimpleCursorAdapter and overrided the bindView() method. This tab is displaying correctly. - Tab 2 is also populated by another adatper that inherit SimpleCursorAdapter and overrided the bindView() method. For some reason that I don't understand, the overrided bindView() is not being called. Thus the tab is not displaying correctly.
Here's my code fragment:
CODE:...........................
Im using the NotePad example as a base for an application. This binds a ListActivity to a Provider.
Its perfect, except it uses SimpleCursorAdaptor, which means the list only binds to and displays one item per row. I want it to display two items, both bound the Provider. Or more accurately display the text from one Content Provider field and an icon which depends on the value of a different field.
This sounds like a pretty simple thing to do, a very slight modification to the NotePad application. Trouble is, I have no idea on *how* to do it. I really need a starting point, and "approach" to use.
So far I have tried (unsuccessfully):
* Hand populating the ListView by reading in the Provider data and populating an array in OnCreate. This works, except as the data is not bound the List does not update when I add an item.
* Extending SimpleCursorAdapter with a custom getViewBinder. Could still only bind to a single column.
* Building my own ListAdaptor. Couldn't get this to work.
* Concatenating both fileds together and "parsing" 2 fields into 1 field read/write.
The next thing I will try is extremely tacky running two separate simpleCursorAdaptors in two views in a Linear Layout, fudged so the row height is identical, and duplicate the logic.
I say this only to show that I really, really have tried.
How I can create a custom CursorAdaptor which binds to two fields instead of just one like SimpleCursorAdapter?
I was poking around in the documentation for the simpleCursorAdapter and I read that if the simpleCursorAdapter doesn't identify your images as resources it will assume they are URIs. My question is how do i retrieve the URI for an image placed into the asset folder of my application?
View 8 Replies View RelatedI know you can set fastScroll for listViews, but currently I would like to use a ListActivity with a simplecursoradapter instead. Is there no way to make such a view fast scroll?
View 1 Replies View RelatedI'm getting some very jerky scrolling while using the code below to create a ListView from a Cursor. Is there something I'm doing wrong, or any way to improve the performance of this ListView?
CODE:.............
Note: bookmarkStore.getCursor() returns an unmanaged cursor from a sqlite database containing the columns from bookmarksColumns.
Suppose I get a cursor that contains all rows from my database, and I want to show them on a spinner, the following code will work. But I want to show two extra items as the spinner elements, how can I add those two elements?
For example, if the following code can show 4 spinner elements "Orange" "Apple" "Cabbage" "Green Onion", how can I add an element in the spinner saying "All fruit" "All Vegetable"?
CODE:....................
With the below code, nothing appears in the ListActivity as I would expect.
No errors are shown in logcat.
CODE:..............
I've got a class that creates a list from a DB using SimpleCursorAdapter. I want to add an onClick event to each item in the list but I don't know where to place the code.
View 1 Replies View RelatedI cant figure out how to perform an onClick on my ListAdapter.
Here is my code:
CODE:.....................
I want to be able to click on an item from the database, then go into a view that only contains info for that item. My class currently extends ListActivity. I've tried OnItemClickListener, but I dont know what else to use to make it work.
I'm trying to change the content of a row in ListView programmatically. In one row there are 3 TextView and a ProgressBar. I want to animate the ProgressBar if the 'result' column of the current row is zero.
After reading some tutorials and docs, I came to the conclusion that LayoutInflater has to be used and getView() - overriden. Maybe I am wrong on this. code...
I have an android list activity that is backed by a database cursor through a SimpleCursorAdapter.
i have one constraint that need to be modify the cursor data. i cannot add the constraint in query.
How should I be update cursor ?
I have a ListView that is backed by a SimpleCursorAdapter. I'd like to be able to filter the list like you would a contacts list, just by typing, and I came across the textFilterEnabled() Problem is, I couldn't see how to get it to work with a SimpleCursorAdapter. Is this even possible?
View 1 Replies View RelatedI juststarted programming in android a few weeks ago, so I am not entirely sure how to deal with listing values. I have some questions regarding displaying data sets from db in a list. Currently I have a cursor returned by my db points to a list of rows and I want display 2 columns values in a single row of the list.
The row xml looks like this:
CODE:...............
so I was thinking using simplecursoradapter which supposedly makes my life easier by displaying the data in a list. However that is only true if I want to display the raw data. For the purpose of my program I need to do some computations on the raw data sets, then display them. I am not sure how to do that using SimpleCursorAdapter.
Here's how I display the raw data:
CODE:.........
Is there a way to do computation on the data in those rows before I bind it with the SimpleCursorAdapter? I was trying to use an alternative way of doing this by using arraylist and arrayadapter, but that way I dont know to how achieve displaying 2 items in a single row.
This is my code for using arrayadapter which only display 1 text in a row instead of 2 textviews in a row:
CODE:.......
It's very obvious that it only displays one textview in a row because I set the second arrayadapter overwrites the first one! I was trying to use R.id.text1 and R.id.text2 for them, but it gave me some errors saying 04-23 01:40:58.658: ERROR/AndroidRuntime(3309): android.content.res.Resources$NotFoundException: Resource ID #0x7f070008 type #0x12 is not valid.
I've been scouring throug the examples and tutorials but I can't seem to get my head around how to handle recycling within a subclassed SimpleCursorAdapter. I know that for regular ArrayAdapters you can check convertView for null and inflate if null from the xml and if not null, recycle, but I'm having a little trouble visualizing how that works with the from and to arrays within the SimpleCursorAdapter subclass. I tried to figure this out from the The Busy Coders Guide to Android Development by Commonsware but was unsuccessful. If anyone knows of any tips, examples, or tutorials, I would be grateful to see them.
View 2 Replies View RelatedI have this scenario
onResume of an activity:
CODE:............
Adapter has been defined as:
CODE:.............
And the onContentChanged event is not fired, although the onResume and the call to the adapter is issued.
My app is mainly made up of a listview linked to a simplecursoradapter (custom one I might add) which in turn uses a cursor which gets the data fed in from a dbadapter class.
using the dbadapter class I can retrieve data using the rawquery and query methods no problem. However I am trying to allow the user to enter a month in and then the app will scroll to that month in the list , instead of the user having to scroll through several months to get there.
This is where I am struggling, I have tried to move to the position within the original cursor and then calling changeCursor from the simplecursoradapter with no luck and tried using the listview with smothscrolltoposition again with no luck and even tried to notifydatachangedset (probably got that named wrong) and then within the custom simplecursoradater try and move to it but that does not work either.
I am seeing the exception in 'adb logcat'.But I don't know if it is caused by my application or android platform.Can you please give me any idea how to troubleshoot this exception?
View 3 Replies View RelatedI'm new to Android, I just finished the Notepad Tutorials, where we can create SQLite Databases to save notes. So I wanted to know if it was possible to "import" my own SQLite database (not created with my App but with a 3rd-party software) to my project, and if the answer is yes, where should I save my SQLite databse and how can I have access to it.
View 9 Replies View RelatedI read in the documentation for SQLite that there should be some core functions and aggregate functions available, but I can't seem to use them in my code.. Can anyone help? Here's the documentation ad: http://www.sqlite.org/lang_aggfunc.html http://www.sqlite.org/lang_corefunc.html There is for example the function count() but how do I use it? I have tried to use it as stated below, but none of the functions in the documentation is available that way (i.e when I type "db." the list that shows in Eclipse documentation doesn't include any of the functions from the SQLite doc except from execSQL):
Code...
I'm doing a application that will use a database with serialized object. The objects will be already serialized and the user will just display things. On a PC I would just make an XML but with android I'm not sure. Can I make an XML and "unpack" it when the user launch the application for the first time or should I do something else?
View 3 Replies View RelatedI put my database field in "assets" folder. And use the code from this blog to copy the database to "/data/data/my_packname/databases/", (This copy code i run it in the onCreate() method when i run this app) then use select * from ... to get data. But it gives me the exception: no such table. Someone told me that if i am attempting to copy the file in SQLiteOpenHelper's onCreate(), it's too late. So the copy file code can not copy the complete file. So i need to use adb or ddms to pull the database first? So, Anyone can teach me how to use my own databse?
View 3 Replies View Related