0

I'm developing an Android app with a SQLite database in WM21 but I can't find the way to execute SQL statements like ALTER TABLE.

Query editor don't suport this kind of statements, function HExecuteSQLQuery() declares this query to the HFSQL engine and fails, and SQLExec() doesn't work because SQLConnect() isn't avaliable in Android.

Exists any way to do this with WM21?

Hector Badenes
  • 13
  • 8

1 Answers1

0

Did you try to declare you table with the HDeclareExternal function and execute SQLExec on it ?

http://doc.windev.com/en-US/?3044204&name=hdeclareexternal_function

Bidjes
  • 166
  • 4
  • 10
  • It throw an error with code 73001: `In Java, HDeclareExternal is allowed on the HFSQL Classic or HFSQL Client/Server data files only.` – Hector Badenes May 20 '16 at 14:51