This return this.editStmt.execute(); // gives error , how to code in Android/sqlite?

[Leonidas Savvides]

This
return this.editStmt.execute(); // gives error , how to code in Android/sqlite?

	private SQLiteStatement editStmt;
	
	public static int idedit;

	private static final String EDIT = "update "
	      + TABLE_NAME + " set name=?,number=?,skypeId=?,address=? where id=?";
	
...................................		
...................................
this.editStmt = this.db.compileStatement(EDIT);
...................................
...................................
public long edit(String name,String number,String skypeId,String address) {
				      this.editStmt.bindString(1, name);
				      this.editStmt.bindString(2, number);
				      this.editStmt.bindString(3, skypeId);
				      this.editStmt.bindString(4, address);
				      this.editStmt.bindLong(5, idedit);
				      
				      return this.editStmt.execute();
}	
...................................
public void setEdit(int id) {
				idedit = id;			
}

			   

[Ulf Dittmer]

How many times has it been by now that you've been asked to provide exact error messages and stack traces for the problems you post about? TellTheDetails

[Leonidas Savvides]

if in
return this.editStmt.execute();
remove return no error, if exist is about returned void result rather long... well ,
anyway.. execute(); is correct command to execute edit/update?

[Perry Hoekstra]

The first problem I see is that your edit method returns a long yet the method whose result you are trying to return is void.

I recommend that you look at the JavaDoc for SQLiteStatement found here: http://developer.android.com/reference/android/database/sqlite/SQLiteStatement.html

In it, you will find that execute returns a void, not a long.

Perry Hoekstra

[Perry Hoekstra]

Once you get your code straightened out, I would highly recommend reading: http://developer.android.com/guide/topics/data/data-storage.html#db

Then you can take a look at: http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html which will give you a list of the standard methods you can execute against your database.

In your case, execute is a JDBC method on the Statement object (http://download.oracle.com/javase/1.4.2/docs/api/java/sql/Statement.html).

That is not to say that you cannot use JDBC against a SQLite database, you just need to make sure you have a SQLite JDBC client for it.

Perry Hoekstra