sqlquery: Insert into issue
Posted: July 10th, 2018, 12:19 pm
Dear All,
I'm trying to insert some items into table previously created.
1.- I create table : string sqlReq = maketext("CREATE TABLE IF NOT EXISTS identifiant_questionnaire (idTable INTEGER AUTOINCREMENT NOT NULL, codetablet INTEGER,codeutilisateur INTEGER, numeroquestionnaire INTEGER)");
sqlquery(SQLITEDB,sqlReq);
2.- I insert data:
string sqlReq2 = maketext ("INSERT INTO identifiant_questionnaire VALUES (%v,%d, %v, %v)",CODE_ENQUETEUR,noTablet(),CODE_OPERATEUR,IQ_1_NUMERO_DU_QUESTIONNAIRF);
warning ("requete la se %v",sqlReq2);
sqlquery(SQLITEDB,sqlReq2);
But, unfortunately, noone data has been inserted. What i'm doing wrong with insert into?
Thanks in advance for your support!
I'm trying to insert some items into table previously created.
1.- I create table : string sqlReq = maketext("CREATE TABLE IF NOT EXISTS identifiant_questionnaire (idTable INTEGER AUTOINCREMENT NOT NULL, codetablet INTEGER,codeutilisateur INTEGER, numeroquestionnaire INTEGER)");
sqlquery(SQLITEDB,sqlReq);
2.- I insert data:
string sqlReq2 = maketext ("INSERT INTO identifiant_questionnaire VALUES (%v,%d, %v, %v)",CODE_ENQUETEUR,noTablet(),CODE_OPERATEUR,IQ_1_NUMERO_DU_QUESTIONNAIRF);
warning ("requete la se %v",sqlReq2);
sqlquery(SQLITEDB,sqlReq2);
But, unfortunately, noone data has been inserted. What i'm doing wrong with insert into?
Thanks in advance for your support!