query.exec("create table user (UPI int primary key, firstname varchar, lastname varchar, cos int )");
query.exec("insert into person values(380142, 'Danny', 'Young',10)");
query.exec("insert into person values(102222, 'Christine', 'Holand',23)");
//The following requests create the tables, but don't insert the data
query.exec("create table destination (number int primary key,type varchar)");
query.exec("insert into destination values(0022921301074, 'local')");
query.exec("insert into destination values(002217780216, 'international')");
//The requests below gives an error message
query.exec("create table callId (id int primary key, ext int)")/*, day varchar, moment varchar,duree int,transfer int, transferExist bool,cosExist bool, number int, cos int)")*/;
query.exec("insert into callId values(' ', '2011-10-28','17:25',128,3300,'true','false',0022921301074,' ')");
query.exec("insert into callId values(' ', '2011-10-29','00:29',128,' ','false','true',002217780216,10)");
QSqlQuery query;
query.exec("create table user (UPI int primary key, firstname varchar, lastname varchar, cos int )");
query.exec("insert into person values(380142, 'Danny', 'Young',10)");
query.exec("insert into person values(102222, 'Christine', 'Holand',23)");
//The following requests create the tables, but don't insert the data
query.exec("create table destination (number int primary key,type varchar)");
query.exec("insert into destination values(0022921301074, 'local')");
query.exec("insert into destination values(002217780216, 'international')");
//The requests below gives an error message
query.exec("create table callId (id int primary key, ext int)")/*, day varchar, moment varchar,duree int,transfer int, transferExist bool,cosExist bool, number int, cos int)")*/;
query.exec("insert into callId values(' ', '2011-10-28','17:25',128,3300,'true','false',0022921301074,' ')");
query.exec("insert into callId values(' ', '2011-10-29','00:29',128,' ','false','true',002217780216,10)");
To copy to clipboard, switch view to plain text mode
Bookmarks