Hello there,
can somebody tell please, how can I execute many SQL commands seperated by semi-column (; ) in SQLite and B4A.
I see that ExecNonQuery is executing only one command.
The commands I 'd like to use are usually CREATE and INSERT.
Here is a example:
Thank you in advance
can somebody tell please, how can I execute many SQL commands seperated by semi-column (; ) in SQLite and B4A.
I see that ExecNonQuery is executing only one command.
The commands I 'd like to use are usually CREATE and INSERT.
Here is a example:
B4X:
CREATE TABLE "CNM_AREA" ("id" INTEGER PRIMARY KEY NOT NULL UNIQUE , "name" VARCHAR);
CREATE TABLE "CNM_CINEMA" ("id" INTEGER PRIMARY KEY NOT NULL UNIQUE , "area_id" INTEGER, "name" VARCHAR, "location" VARCHAR, "descr" VARCHAR, "page" VARCHAR);
CREATE TABLE "CNM_MOVIE" ("id" INTEGER PRIMARY KEY NOT NULL UNIQUE , "name" VARCHAR, "name_gr" VARCHAR, "gender" VARCHAR, "descr" VARCHAR, "image" VARCHAR, "stars" INTEGER);
Insert into CNM_AREA (id, name) values (1, 'area1');
Insert into CNM_AREA (id, name) values (2, 'area2');Thank you in advance