vendredi 7 août 2015

SQL Query issue

Struggling to get SQL query to work since morning. I am trying to check if particular field has 0 value only for first 500 records.

I tried the following:

SELECT * FROM UnMappText  WHERE updateTime = '0' desc LIMIT 0, 500;

This gives me the below error:

Process: com.ylg.dbaccess, PID: 18738
    android.database.sqlite.SQLiteException: near "desc": syntax error (code 1): , while compiling: SELECT * FROM UnMappText WHERE updateTime = '0' desc LIMIT 0, 500
            at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
            at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
            at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
            at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
            at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
            at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
            at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
            at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1316)
            at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1255)
            at com.ylg.dbaccess.UnMappText (DBValue.java:3312)
            at android.os.Handler.handleCallback(Handler.java:739)
            at android.os.Handler.dispatchMessage(Handler.java:95)
            at android.os.Looper.loop(Looper.java:135)
            at android.app.ActivityThread.main(ActivityThread.java:5254)
            at java.lang.reflect.Method.invoke(Native Method)
            at java.lang.reflect.Method.invoke(Method.java:372)
            at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
            at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)

So I tried the following way:

SELECT * FROM UnMappText WHERE updateTime = '0' ORDER By updateTime LIMIT 0, 500;

This gives me a result but doesn't give result for first 500 records but just gives 500 records results.

How do I get to check updateTime has 0 for first 500 records?

Aucun commentaire:

Enregistrer un commentaire