Android Question Delete with where clause shows error

Discussion in 'Android Questions' started by Makumbi, Jul 20, 2019.

  1. Makumbi

    Makumbi Active Member Licensed User

    Code:
    Starter.SQL1.ExecNonQuery("DELETE Alevelreport  WHERE Points=F;")
    this is the error that comes please help
    Code:
    android.database.sqlite.SQLiteException: near "Alevelreport": syntax error (code 1): , while compiling: DELETE Alevelreport  WHERE Points=F;
     
  2. Pendrush

    Pendrush Well-Known Member Licensed User

    Code:
    Starter.SQL1.ExecNonQuery("DELETE FROM your_table_name WHERE Points=F;")
     
    Erel and Makumbi like this.
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice