Accessing an SQL database
Posted: Mon Apr 20, 2020 9:29 pm
From a QCAD user:
How can I access an SQL database from my script?
How can I access an SQL database from my script?
Code: Select all
var db = QSqlDatabase.addDatabase("QSQLITE", "MyConnection");
db.setDatabaseName("mysql.sql");
db.open();
db.transaction();
var query = new QSqlQuery(db);
var ret = query.exec("CREATE TABLE IF NOT EXISTS MyTable (id INTEGER)");
db.commit();