Beiträge von kevins391

04-27 23:41:45.003: ERROR/AndroidRuntime(9361): FATAL EXCEPTION: main
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): java.lang.RuntimeException: Unable to start activity ComponentInfo{de.kevins391.dblite/de.kevins391.dblite.dbliteActivity}: android.database.sqlite.SQLiteException: near "alter": syntax error: CREATE TABLE IF NOT EXISTS users (_id integer primary key autoincrement,name varchar(100),alter varchar(100));
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2663)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2679)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at android.app.ActivityThread.access$2300(ActivityThread.java:125)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2033)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at android.os.Handler.dispatchMessage(Handler.java:99)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at android.os.Looper.loop(Looper.java:123)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at android.app.ActivityThread.main(ActivityThread.java:4627)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at java.lang.reflect.Method.invokeNative(Native Method)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at java.lang.reflect.Method.invoke(Method.java:521)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:871)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:629)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at dalvik.system.NativeStart.main(Native Method)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): Caused by: android.database.sqlite.SQLiteException: near "alter": syntax error: CREATE TABLE IF NOT EXISTS users (_id integer primary key autoincrement,name varchar(100),alter varchar(100));
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at android.database.sqlite.SQLiteDatabase.native_execSQL(Native Method)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1836)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at de.kevins391.dblite.dbliteActivity.onCreateDBAndDBTabled(dbliteActivity.java:20)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at de.kevins391.dblite.dbliteActivity.onCreate(dbliteActivity.java:15)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2627)
04-27 23:41:45.003: ERROR/AndroidRuntime(9361): ... 11 more
04-27 23:41:45.042: WARN/ActivityManager(2473):   Force finishing activity de.kevins391.dblite/.dbliteActivity

package de.kevins391.workshop;


import android.app.Activity;
import android.os.Bundle;
import android.content.Intent;
import android.view.View;
import android.widget.TextView;


public class test extends Activity {
	
	@Override
	public void onCreate(Bundle savedInstanceState) {
    	super.onCreate(savedInstanceState);
    	setContentView(R.layout.main);	
	}
	
	public void fotoaufnehmen(View target) {
		Intent intent = new Intent("android.media.action.IMAGE_CAPTURE");
		startActivityForResult(intent,0);
	}  
	
	@Override
	protected void onActivityResult(int requestCode, int resultCode, Intent data) {
    	if (requestCode== 0 && resultCode == Activity.RESULT_OK){
           	
            	String result = data.toURI();
            	TextView resField = (TextView) findViewById(R.id.textView1);
            	resField.setText(result);


    	}
	}
}

package de.kevins391.dblite;


import android.app.Activity;
import android.os.Bundle;
import android.database.sqlite.*;


public class dblite extends Activity {		
	SQLiteDatabase myDB = null; 
	final static String MY_DB_NAME = "kevins391";
	final static String MY_DB_TABLE = "users";
	
	@Override
	public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		onCreateDBAndDBTabled();
		setContentView(R.layout.main);
	}
	private void onCreateDBAndDBTabled() {
		myDB = this.openOrCreateDatabase(MY_DB_NAME, MODE_PRIVATE, null);
		myDB.execSQL("CREATE TABLE IF NOT EXISTS " + MY_DB_TABLE
	            		  + " (_id integer primary key autoincrement,"
	                  	+ "name varchar(100)," 
	                  	+ "alter varchar(100))" 
	                  	+ ";");
		}
}