test form MYSQL is ok :
"SELECT name FROM " & DBTableName & " WHERE (left(name,1)) ='C'"
but for this is not ok on sqllite-android.
message error :
cur = SQL.ExecQuery(Query)
androir.databse.sqlite.sqlexcepion:near "(":syntax error (code1):
while compiling:.....
what is equivalence for lesft(name,1)='C'
thank you for your help
"SELECT name FROM " & DBTableName & " WHERE (left(name,1)) ='C'"
but for this is not ok on sqllite-android.
message error :
cur = SQL.ExecQuery(Query)
androir.databse.sqlite.sqlexcepion:near "(":syntax error (code1):
while compiling:.....
what is equivalence for lesft(name,1)='C'
thank you for your help