Can't write into database

[Babs]

@artwaw thanks you. I moved my database and tableCreation in my main function. I assume that it's called only once then. It still doesn't work. By printing lastError().txt i get the following message:
SqlQuery::prepare: database not open
"Driver not loaded Driver not loaded"

[artwaw]

@Babs Ok. So now you can test db.open() - it returns a value. On false, error should be present in lastError().

[Babs]

@artwaw it returns false and the error driver not loaded. I do the verification:

        if(!db.isOpen()){
            db.open();
            qDebug()<<db.lastError().text();
        }

[artwaw]

@Babs Are you completely sure that addDatabase() has been called at any point before call do QSqlDatabase::database()?
You could also test if driver is available by using QSqlDatabase::drivers() and other methods described in documentation.

[Babs]

@artwaw do i have to specify the connectionName when calling database() function?. Add data base in called in my main function before creation my engine.

[Babs]

@artwaw the driver for SQLite is indeed present.

[artwaw]

@Babs can you post your .pro files please?

[Babs]

@artwaw i'm working with QBS. When i don't specify the connectionName in addDataBase() function it open. I have the error "number of parameters incorrect". I think i don't have the good parameter types. I defined a QString as a TEXT is SQLite. Is it correct?

[Babs]

@artwaw here is my QBS file

import qbs



Project{
    name: "PlanningModrian"

    Product{
        files: [
        ]
        name: ( "modrian");
        type: "application";
        targetName: (project.targetPrefixTools + "modrian");
        cpp.dynamicLibraries: {
            var ret = [];
            if (Qt.core.versionMinor < 4) { // NOTE : prior to Qt5.4 we had to link libGL manually
                ret.push ("GL");
            }
            return ret;
        }

        cpp.cxxLanguageVersion: "c++14"
        readonly property stringList qmlImportPaths : [sourceDirectory + "/import"]; // equivalent to QML_IMPORT_PATH += $$PWD/import

        Depends { name: "Qt.quick" }
        Depends {
            name: "Qt";
            submodules: ["core", "gui", "qml", "quick","testlib","sql"];
        }
        Group{
            name: "C++ sources";
            files: [
                "planning.cpp",
                "main.cpp",
                "admin.cpp",
                "testPlanning.cpp",
                "user.cpp",
                "equipement.cpp",
                "equimenttablemodel.cpp",
                "palier.cpp",
                "paliermodel.cpp",
                "appwrapper.cpp",
            ]
        }
        Group {
            qbs.install: (product.type === "dynamiclibrary");
            fileTagsFilter: product.type;
        }

        Group{
            name: "C++ headers";
            files: [
                "admin.h",
                "appwrapper.h",
                "datetimevalidator.cpp",
                "datetimevalidator.h",
                "equimenttablemodel.h",
                "manager.cpp",
                "manager.h",
                "paliermodel.h",
                "planning.h",
                "user.h",
                "equipement.h",
                "palier.h",
            ]
        }
        Group  {
            name: "QML files"
            files: [
                "DatePicker.qml",
                "DateUtils.js",
                "Planning.qml",
                "main.qml",
                "PagePlannification.qml",
                "qml.qrc",
            ]
        }

        //Depends { name: (project.namePrefixBase + "utils"); }
        Depends { name: "libqtqmltricks-qtsupermacros"; }
        Depends { name: "libqtqmltricks-qtqmlmodels"; }
        Depends { name: "libqtqmltricks-qtquickuielements"; }
    }
}

[artwaw]

@Babs ups. I have literally zero experience with qbs...
I am afraid you'll have to wait for someone who knows something about it, I am sorry.

[Babs]

I resolved my problem. I made an error in the type an name of one of the parameters. Thanks for your help @artwaw.

[artwaw]

@Babs Anytime.
Please don't forget to mark the thread as "solved".