SQLite3 doesn't support stored procedures. Is it possible to write custom function on C/C++ and use it in SQL query?
Something like that
SELECT * FROM table WHERE CUST_FUNCTION(name1, name2) = 1
or
SELECT CUST_FUNCTION(name1, name2) FROM table
Maybe you have some good example how to do that.
View 1 Replies
I am trying to write a select query from one single table in SQLite DB in my app where data exists.
This is the SQL.table has these columns - id(INTEGER), start_time(INTEGER), category(TEXT)
select category from tuuserid_pref where id = (select max(id) from tuuserid_pref
where start_time < '1242'); by the way I want to bind the value shown in 1242 which I have in an Integer variable.
I have written selects and inserts and updates without binding parameters and they work using db.execSQL and db.rawQuery functions but just cannot figure the binding parameters out.
How do I write a custom screen locker? Where is the source of the default screen locker? Any links on writing custom screen lockers?
View 3 Replies View RelatedI been using custom adapters based on the BaseAdapter and I usually populate my data at the getView() funtion.
Now I'm trying to write my custom adapter for my database cursor which now will be based on a CursorAdapter.
I'm getting confused where I should do the populating work? Along with how do I implement my inflating and populating "smart/efficient code based on RomainGuy presentation."
I want to run this query in Android Application :
code:.......
My DB schema
code:..........
Here is the function -
code:...........
I am trying to build a custom toggle button in Android, I want it to look like radio button but function as toggle button.
View 3 Replies View RelatedNot sure of the absolute utility of this but seems as though it should be possible and useful. Can you extend ContentProvider to provide URIs representing new queries (i.e., joins across multiple tables not specified by existing URIs) for an existing system database? The alternative seems to be that I need to write a series of cursor queries then join them -- seems like a lot of unnecessary code duplication.
I have been trying this for the contacts database as an exercise, but no love so far. The crux seems to be that I cannot open a database in another package during the setup phase. Am I just completely out in left field here? It's possible as I am new to both Java and Android.
I have a class that extends View. I override the onDraw method and allow the user to draw on the screen. I am at the point where I want to save this view as an image. I Can use buildDrawingCache and getDrawingCache to create a bitmap that I can write to the SD card. However, the image is not good quality at a large size, it has jagged edges. Since I have a View and I use Paths I can transform all by drawing to a bigger size. I just don't know how to make the Canvas bigger so when I call getDrawingCache it doesn't crop all the paths I am just transformed. What is happening is I transform all my paths but when I write the Bitmap to file I am only getting the "viewport" of the actual screen size. I want something much bigger.
View 1 Replies View RelatedI have two published apps that are pretty targeted to the user collecting their personal medical data (like Blood Pressure, etc.) and then, eventually sending it somewhere, if they choose.
I decided to put Read/Write permission on my ContentProvider, so if another app comes along that wants to the access that content, the user will be warned. The permission that is required is declared in my apps.
When the user installs my apps, they are also given a warning that the app requires that permission (even though it's the one that declares it), and it shows up in the Marketplace also.
The question is: Is it possible that the permission acceptance part of installing my app could be putting customers off? I don't know what other's acceptance rate is, but mine is around 50% of customers who download it have active installs.
In my app I need to query both the SMS and the MMS log to get the history of all incoming and outgoing messages.
This code has worked wonderfully for SMS:
CODE:......
But when I try the following I get completely different results:
COD:....................
The SMS query returns data that includes the message address (phone number), contact name, message subject, message body, etc... The same query for MMS returns a bunch of nulls or numeric value fields that I can't make any sense of. I really need a list of all MMS messages currently on the phone with the phone number or contact ID associated with it, and if the message was an incoming or outgoing message. In the SMS query results I can get the phone number from the address field, and the incoming/outgoing type from the type field but neither of these exist when I query for MMS.
Is there a different content Uri that I need to query for this sort of MMS data?
Is there a way to access and query the android SMS/MMS log? To clarify, the SMS/MMS Log is all the SMS/MMS messages sent by the host phone. It can be aquired by reading a cursor to the message inbox.
View 2 Replies View RelatedIs it possible to query a website's api from an android app? If so, how to do you handle the return if it's in xml?
View 1 Replies View RelatedI have a sql query like this
String loadFav = "SELECT _id, title, name, favorite FROM table1 where favorite= 1 "
+ "UNION ALL"
+ "SELECT _id, title, name, favorite FROM table2 where favorite= 1"
Cursor mCursor = mSQLiteDatabase.rawQuery(loadFav, null);
I got an error when run this query. Is it right structure?
How can I query the latest sms of every conversation. just like native sms application in the android phone.
everytime we start the sms application, it displays the conversations sorted by date. how can I achieve this?
we can query all the sms, but I can't figure out how to query the sms by threads.
I have created a database for my android app which contains static data and does not require update/delete functionality thus when the app starts, I want to check if the db exists and if not then execute my dbAdapter class. I know its a simple if statement but I was just wondering the most efficient way to query whether the db exists.
View 2 Replies View RelatedAm a beginner in this area. I am trying to find out how a DNS query is sent from the android device. Am unable to locate the code. Nees code where a DNS query is sent. For example, may be from some application like browser?
View 9 Replies View Relatedi have a problem querying out sms message from the smsinbox. currently i able to display the sms messages using a listview. what i trying to do is once the user select the msg from list view and a Toast will display (with the msg content) once selected.
View 2 Replies View RelatedI have got around 15 buttons in my activity.
I just wanted to know that what would be a better approach to implement their ClickListeners. Should I write a single ClickListener and use Switch case or I should write it individually fr each button?
I got confused between these two because on a couple of blogs, it is suggested to write individual ones from the viewpoint of performance and efficiency but, considering cumbersome and complexity of overall code I feel like going with approach 1 i.e. switch case. Kindly give your suggestions about the right approach and the reason why I should prefer that.
I know there isn't bluetooth API in 1.0 SDK, but I have a doubt. I need to know the visible bluetooth devices. That is, I only need do a scan of the bluetooth devices and save the diferent addresses. I don't need connect to them.
I have read here
http://groups.google.com/group/android-beginners/browse_thread/thread...
that API "only expose functionality to use/control headsets (audio profile)."
And now my question: It is possible do this functionality? Can I find which bluetooth devices are visible?
I am about to start writing a web app for the latest smart phones using HTML5, CSS3 and JavaScript. I donut need a framework so much as a library like j Query. I looked at jQ Touch which is great for i Phone and apparently has support coming for Android too but I am looking to cover Blackberry device Software v4.6 upwards and WebOS 5 as well. Does anyone have any ideas of alternatives to jQ Touch or experience using jQTouch with Android's native browser, Blackberry's browser or Web OS native browser?
View 4 Replies View RelatedI'm want to implement Dynamic SlideShow of Images similar to Gallery. On Drag, i Should be able to change to next images. I'm looking into Gallary1.java class from APIDemo Example, i think there is no sufficient information in that, so is there any better code example.
View 2 Replies View RelatedMy Android app has a ContactsList activity in which I simply display a list of contacts that are on the phone. Only recently I noticed that my activity only displays contacts synced with my main Google account. I have two Google accounts on my test phone and ideally I want my activity to display the contacts for both accounts (or multiple accounts). How do I query across multiple accounts?
View 2 Replies View RelatedI am trying to write a simple test framework. This is what I want to do: My actual test is an apk file on android device, and I write a TestCase or some instrumentation for that which runs on host side. I trigger the test using adb commands or some IDE.I am able to refer to some examples which does above.Now what I want to know is any way of getting results back using any api available in TestCase or such class.This result can be any string value or an object too.
1. can I use TestResult for this purpose ? I expect it ot be similar to function calland return value from function.i.e. on completion of test I should get back the result in a structured way probably defined by me.Is this possible at all.
2. or return value is always going to be put to stdout? or logcat?
3.how do I parse and collect stdout or logcat prints into a file?
any input would be of great help.
I have sounds files in my res/raw folder and i want to select a sound to set as a ringtone on the click of a button. Wonder how can i do that?
View 2 Replies View RelatedCan you please tell me how can i query the number of unread SMS in android programmically? i.e. How can I implement the SMS unread count like this link: http://android.kanokgems.com/sms-unread-count/.
View 2 Replies View RelatedI create a table like that
CODE:...........
I update it this way
CODE:..........
I do see the change in eclipse with DDMS questoid
But when i try to retrieve the value I get nothing ....
CODE:.........
I've tried some variant like
CODE:............
With no success
Is this problem come from the type (integer) of my column ?
I use this query in my android database, but It return no data. Am I missing something?
CODE:................
I successfully created the Database and inserted a row however I cannot Query it for some reason. My Droid crashes everytime.
CODE:...........
I get this exception
No such column: value: , while compiling: SELECT DISTINCT value FROM mainTable
I have a query that pulls everything from a database into a list view.
code:..........
I want only the records where the field KEY_HOMEID matches a variable called journalId which should be a numeric string.
I would also like to know how to bring the variable into my DatabaseAdapter... would ((resource)this.getApplication()).getjournalId()) work? resource is a class that extends application.
I'm trying to reduce the number of queries I do to the Android's database. Basically I want to get any email or IM address that contains a user defined search term. Right now I'm doing two separate queries:
Email:...............