See title for explanation.
Here is the method I'm using:
CODE:.........
And here is the call to the method:
CODE:...........
Why it would be throwing the "No Column Found with name=Test", although my DB explorer shows there is indeed a column named name and a value in a row named Test?
View 1 Replies
I have a bit of code that takes a list of contact ID's that have been selected and return a cursor with other data I might be interested in for those ID's.
CODE:............
I have a weird issue. I receive the following error that causes a force-close:
CODE:...........
After clicking the Force Close button, the Activity is recreated and the parsing completes without a hitch. I'm using the following code snippet inside doInBackground of an AsyncTask:
CODE:.......................
Why would the Activity force-close and then run without any problems immediately after? Would a BufferedInputStream be any different? I'm baffled.
It turns out HttpURLConnection.getResponseCode() returns -1 every so often, so the InputStream probably isn't being correctly set.
I am trying to utilize what has allready been written for this, in my own database
I will actually post my code so someone may be able to pick out what is wrong
This is the error i get: 06-21 19:57:35.511: ERROR/AndroidRuntime(796): Caused by:
code:................
This is the method its faulting on in Class:
code:..............................
I have an activity that starts a long-running service which in turn adds an icon to the status bar. When the activity gets invisible, e.g. by pressing the Home button, and the pressing the icon in the status bar a new activity is created instead of showing the already created activity. If you now press the back button the new activity is destroyed and the activity created in the first place gets visible. How do I make the invisible activity brought to front when pressing the icon in the status bar instead of creating a new activity?
View 1 Replies View RelatedCan I create index on a column in the create table command in sqlite?I tried this command below in sqlite3 in Android shell. It seems to work.But, in sqlite's query language specification, specifying a column to be indexed is not supported.
View 1 Replies View RelatedI have a database that I download external and save on my sdcard. But this database is also used for an iPhone app and has a column id and not _id (sqlite uses _id). How can i rename this column to _id?
View 4 Replies View RelatedI have a friend call David with phone number 11223344. I cannot see his phone from contact list. But when i dial his number, I can see his name when i type 1122. But when David calls me, as it is not in contact list, the phone only display 11223344 as incoming call, rather than his name. My phone is LG P990.
View 2 Replies View RelatedI have a TEXT column and I want to match all rows where the value has a certain prefix. For example, WHERE mycol LIKE 'myprefix%' However, I noticed in some optimization guidelines that this will not use the index and instead you should do this:WHERE mycol >= 'myprefix' AND mycol < 'myprefiy'Instead of simple A-Z chars, I have a whole variety of UTF-8 chars (think chinese characters).My question is, how to work out the next char in UTF-8? Is it enough to add one to the codepoint,
View 3 Replies View RelatedSo I have an app on the market, and with an update I want to add some columns to the database. No problems so far. But I want to detect if the database in use is missing these columns, and add them if this is the case. I need this to be done dynamically and not just after the update to the new version, because the application is supposed to still be able to import older databases. Normally I would be able to use the PRAGMA query, but Im not sure how to do this with Android. I cant use execSQL since it is a query, and I cant figure out how to use PRAGMA with the query()-function.
Ofcourse I could just catch exceptions and then add the column, or always add the columns to each table before I start to work with it, but that is not a neat solution.
I am trying to update a datetime column in an android sqlite db to use international date format (yyyy-mm-dd) instead of the current format (mm/dd/yyyy). I want to use the sqlite date() function to reformat the current value of the column. I thought it would be as simple as the following: update tblename set thedate = date(thedate)
But the above does not work.
How would i write the sql statement to accomplish this?
I'm working on an Android App where the user has different options for sorting the displayed data that comes from the database. Currently my orderBy string that I pass to Androids query() method looks like this:
"LOWER("+columnName+") ASC"
The problem with this is that if the data type in the column specified by columnName is integer, calling LOWER() on it will cause it to be sorted alphabetically, i.e. based only on the leftmost digit, which of course doesn't make any sense for numeric data. Hence I only want to apply LOWER() if the data type of the column is not integer. What I have in mind is a statement like this:
"CASE WHEN [data type of columnName is integer] THEN "+columnName+" ASC ELSE LOWER("+columName+") ASC END"
The part in the brackets is what I don't know how to do. Does SQLite provide a function to determine a column's data type?
I'm attempting to create a method that will allow me to retrieve a value from the last row of a database, and then insert it into an EditText field. (This is a value that the user will not change all that often, so it would be helpful if when they do set it, it stays set when they come back to it).
My method, based on a similar method I have for getting the total of a specific column, is as such. code...
If I run the program without this statement, it works fine and the value saves to the db. As soon as I try to run it with this, I get a force close. Any suggestions?
I am using sqlite database in andriod. i m not creating any database i m using created database and it has successfully opened but when i am using:
Cursor cursor= db.query(tablename, null, null, null, null, null, null);
Then it gives this table does not exists plz help me.i got frustated with this problem. i also googled this problem but didnt find exact solution.
Is there a way to check and see if an Activity exists on your device? If I have a youtube video link I want to specify it open in the YouTube PlayerActivity. However, I don't want to crash if for some reason they don't have it.
Is there a way to check and see if the activity exists? I don't think I can catch the runtime exception since startActivity() doesn't throw it.
I have a Tabview with 3 tabs (each having their own activity). I have a tab that parses a RSS feed. How can I refresh this feed via a menu button? I tried doing the following but I lose the tabs above of course.
CODE:.................
I am developing an application in android allowing the user to maintain his weight by providing him diet suggestions. I have done with that part and now, I need to display user weight tracking details using bar graph. I am able to fetch the Weight and Login date column data from the sqlite database to List<String>. I don't understand the way to put these values into a Bar Graph with Date Column data as X-axis and Weight column data as Y-axis.
View 1 Replies View RelatedI created a sql lite database with the following columns:
static final String dbName="demoDB";
static final String tableName="Employees";
static final String colID="EmployeeID";
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL("CREATE TABLE "+tableName+" ("+colID+" INTEGER PRIMARY KEY AUTOINCREMENT, "+
colName+" TEXT, "+colAge+" Integer);");
I want to select all the records in the database like this and display them in a gridview:SQLiteDatabase db=this.getWritableDatabase();Cursor cur= db.rawQuery("Select "+colName+", "+colAge+" from "+tableName, new String [] {});String [] from=new String []{DatabaseHelper.colName,DatabaseHelper.colAge};
int [] to=new int [] {R.id.colName,R.id.colAge};
SimpleCursorAdapter sca=new SimpleCursorAdapter(this,R.layout.gridrow,c,from,to);
GridView grid=(GridView)findViewById(R.id.grid);
grid.setAdapter(sca);but i receive the following exception:java.lang.IllegalArgumentException: column '_id' does not exist.the db table does not have a column with name '_id'so what is wrong with this code
I would like to have my list activity to display 2 items(title, content) in a single row. I have almost 10 rows to display like that. And I want the width of the columns to be equally spread out. I tried with linear layout and table layout, but I could not bring the columns equally sized. I am using the following layout. kindly help me and advice me on this....
code.............
I am using startActivity to call another Activity and I get the "Activity Not Found Exception".
Here is my code:
CODE:......
Here is the Logcat output:
CODE:.....
Here is the debug window output:
CODE:.....................
symptomRemedyActivity is another activity in my project. Is there something I need to do like importing symptomRemedyActivity so that startActivity can see symptomRemedyActivity, to remove this "Activity Not Found Exception"?
So today I had a bright idea to rename my packages, now my android application which I have schedule for release on Thursday is not working.
I am getting a similar error as follows:
Error: Activity class {org.me.androidapplication2/com.albertrosa.DEMO.MainActivity} does not exist.
I have modified the manifest to reflect the change:
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
package="com.albertrosa.DEMO"
android:versionCode="1"
android:versionName="1.0"
there is more to the manifest but this is all that I have changed. is there something I am missing or doing wrong. I am using netbeans to build this app.
I am tring to invote internal media player of android from my activity. Seems there is some problem in menifest file .
Please look into this issue .
CODE:...........................
I have a problem regarding my intent. It seems that my app crashes when i select the intent. I found the line of error code due to the stack trace. But i couldn't find anything wrong with it. Hope anyone can help me with this.
This is the java code in line 121:
CODE:..............
This is the stack trace:
CODE:....................................
This has got me all confused! I'm trying to return the max value from a column in my database but the return value is always the name of the column.
The query I use:
private static final String SELECTMAX = "SELECT MAX(?) FROM " + TABLE_NAME ;
The (test) function to return the max value:
CODE:............
The column i'm querying is an INTEGER type but the result 's' is always the column name and not the desired value.
I am playing with "android.speech.action.RECOGNIZE_SPEECH" and in the source it says to trap for ActivityNotFoundException. However, I am not sure how I can do this, the activity class doesn't support this event. I found it as part of android.content, but am not sure how to implement it. Multiple inheritance?
View 2 Replies View RelatedThe JavaDoc of Context's public abstract void startActivity (Intent intent) said:
This method throws ActivityNotFoundException if there was no Activity found to run the given Intent.
But when I look at the android source code, it does not catch ActivityNotFoundException.
For example in AlarmClock.java:
CODE:..................
what is the code which handles the case when there is no activity for that intent?
test.class type is right? How to? What should I do?
CODE:...............
The error I receive is, "android.content.ActivityNotFoundException: Unable to find explicit activity class {com.droidea.birthday/ EditBirthdayActivity}; have you declared this activity in your AndroidManifest.xml?"
The error seems simple enough, but I don't see a problem with the way I have identified this activity in my manifest file. I have also been unable to see any problems with the activity class itself..............
I'm trying to have my app display my login activity when a user selects add account in accounts&sync or wants to use the app and isn't logged in yet. I've followed the example SampleSyncAdapter fairly closely, but can't get it to work.
In my auth service:
CODE:........
In my manifest:
CODE:........
In my main activity:
CODE:.......
I've tried doing both
CODE:.......
And
CODE:............
Before the startActivity() call, but it still can't find an activity for that intent. If I try to add an account via accounts&sync the app crashes with the same ActivityNotFoundException.
I've examined c99's last.fm app, which defines a custom action and uses intents based on that action rather than android.accounts.AccountManager.ACTION_AUTHENTICATOR_INTENT. Is that a better approach? Is there a way to make it work with Accounts & Sync?
I have been trying to get this program to work but so far having no luck. I cannot find where I am doing wrong. I'm not sure if there's something wrong with the code, or debugging.
Here is my program:
package Technicaljar.SMSBroadcastReceiver;
import android.content.BroadcastReceiver;
import android.content.Context;
import android.content.Intent;
import android.os.Bundle;
import android.telephony.SmsMessage;
import android.util.Log;
public class SMSBroadcastReceiver extends BroadcastReceiver {
private static final String SMS_RECEIVED = "android.provider.Telephony.SMS_RECEIVED";
private static final String TAG = "SMSBroadcastReceiver";
@Override
public void onReceive(Context context, Intent intent) {
Log.i(TAG, "Intent received: " + intent.getAction());
if (intent.getAction() == SMS_RECEIVED) {
Bundle bundle = intent.getExtras();
if (bundle != null) {
Object[] pdus = (Object[])bundle.get("pdus");
final SmsMessage[] messages = new SmsMessage[pdus.length];
for (int i = 0; i < pdus.length; i++) {
messages[i] = SmsMessage.createFromPdu((byte[])pdus[i]);
} if (messages.length > -1) {
Log.i(TAG, "Message recieved: " + messages[0].getMessageBody());
} } } } }
And the manifest file:
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
package="Technicaljar.SMSBroadcastReceiver"
android:versionCode="1"
android:versionName="1.0">
<application android:icon="@drawable/icon" android:label="@string/app_name" android:debuggable="true" >
<receiver android:name=".SMSBroadcastReceiver">
<intent-filter>
<action android:name="android.provider.telephony.SMS_RECEIVED"></action>
</intent-filter>
</receiver>
</application>
<uses-sdk android:minSdkVersion="7" />
<uses-permission android:name="android.permission.INTERNET">
</uses-permission>
<uses-permission android:name="android.permission.RECEIVE_SMS">
</uses-permission>
</manifest>
I am sending SMS through Telnet, and I cannot see any Intent received messages in the logcat. Here is my logcat from the time of installation.
D/AndroidRuntime( 478):
D/AndroidRuntime( 478): >>>>>>>>>>>>>> AndroidRuntime START <<<<<<<<<<<<<<
D/AndroidRuntime( 478): CheckJNI is ON
D/AndroidRuntime( 478): --- registering native functions ---
D/AndroidRuntime( 478): Shutting down VM
D/dalvikvm( 478): Debugger has detached; object registry had 1 entries
I/AndroidRuntime( 478): NOTE: attach of thread 'Binder Thread #3' failed
D/Mms:app ( 220): getSmsNewMessageNotificationInfo: count=14, first addr=12345, thread_id=4
D/dalvikvm( 151): GC_EXPLICIT freed 391 objects / 22552 bytes in 65ms
D/dalvikvm( 220): GC_EXPLICIT freed 926 objects / 44840 bytes in 73ms
So the SMS seems to be received by the emulator, but looks like the no intents are firing.
What am I doing wrong here? After installing, do I have to somehow 'start' this receiver?
Because when I install, I get
[2010-11-07 21:24:41 - SMSBroadcastReceiver] No Launcher activity found!
[2010-11-07 21:24:41 - SMSBroadcastReceiver] The launch will only sync the application package on the device!