compare android database with integer
I want take data which is id in my database external storage and compare with id in database internet. for taking database from internet already done. the problem is I cannot compare both of that data.

I create code which is will take some data from data base like this

<i>File file = new File("/data/data/com.raj.dse/databases/dse");
		        //and connect!

		        SQLiteStatement statement = null;
		        String query = "SELECT MAX(_id) FROM updatetime";
		        db.compileStatement(query);
		        int idex = (int) statement.simpleQueryForLong();

		        if(idex>=max){
		        	handler.post(new Runnable() {
		                @Override
		                public void run() {
		              	  state.setText("Database uptodate...");
		                }
					});
		        }</i>

I saw the logcat and see the problem at
<i>db.compileStatement(query);</i>

I still didn't understand where is the problem.


compare android database with integer
===

I want take data which is id in my database external storage and compare with id in database internet. for taking database from internet already done. the problem is I cannot compare both of that data.

I create code which is will take some data from data base like this

<i>File file = new File("/data/data/com.raj.dse/databases/dse");
		        //and connect!

		        SQLiteStatement statement = null;
		        String query = "SELECT MAX(_id) FROM updatetime";
		        db.compileStatement(query);
		        int idex = (int) statement.simpleQueryForLong();

		        if(idex>=max){
		        	handler.post(new Runnable() {
		                @Override
		                public void run() {
		              	  state.setText("Database uptodate...");
		                }
					});
		        }</i>

I saw the logcat and see the problem at
<i>db.compileStatement(query);</i>

I still didn't understand where is the problem.

