Can you please tell me where the error is, because I spent many nights trying to make combinations in quotes and parentheses. It gives me the following error :
android.database.sqlite.SQLiteException: near "WHERE": syntax error (code 1 SQLITE_ERROR): , while compiling: PRAGMA table_info(MyRts) WHERE cid = FieldNumber
Many thanks
in advanced
android.database.sqlite.SQLiteException: near "WHERE": syntax error (code 1 SQLITE_ERROR): , while compiling: PRAGMA table_info(MyRts) WHERE cid = FieldNumber
Many thanks
in advanced
sql query:
Dim TBQuery As String = "PRAGMA table_info(" & TheTableName & ") WHERE cid = FieldNumber "