StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to query the last sent SMS from content provider?
text
Body
copied!<p>When I send an SMS on my Android emulator, it goes to the content provider:</p> <pre><code>content://sms/sent </code></pre> <p>right?</p> <p>So I wanted to get the last sent SMS from the content provider. So I used this Uri as you can see above and I used the method query, with the Content Resolver Object. And I got the cursor, and used the movetofirst() method, so I would have the last sent SMS. Check the code below.</p> <pre><code>package com.sys; import android.app.Activity; import android.os.Bundle; import android.view.View; import android.widget.Button; import android.widget.EditText; import android.net.Uri; import android.database.Cursor; public class SMS extends Activity { Button btnVerSms; EditText txtFinal; final Uri CONTENT_URI = Uri.parse("content://sms/sent"); /** Called when the activity is first created. */ @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); btnVerSms= (Button)findViewById(R.id.btnVerSms); txtFinal = (EditText)findViewById(R.id.txtFinal); btnVerSms.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { // TODO Auto-generated method stub Cursor cursor = getContentResolver().query(CONTENT_URI, null, null, null, null); String body = null; if(cursor.moveToFirst()){ body = cursor.getString(cursor.getColumnIndexOrThrow("body")).toString(); } txtFinal.setText(body); } }); } } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload