cannot Excecute query in sql

[JonB]

@JonnyQB said in cannot Excecute query in sql:

qry.prepare(QString("SELECT * FROM login WHERE Username=:username and Password :passwort "));

You mean Password=:passwort, just like you did for Username=:username. Please try to look at your code before posting a question on it.

[JonnyQB]

@JonB
after i fixed it i got the same thing

[JonB]

@JonnyQB
Start by printing out query.lastError() after executing statement, as @mrjj said. Almost anything could be the issue. You do not even say what message you get from your code, only "i just cant execute the query". There is also no message for Logindb.open() failing. We cannot guess.

[JonnyQB]

@JonB
Error = "Driver not loaded Driver not loaded"
now should i use another driver or what ?

[JonnyQB]

@JonB
both sqllite and mysql are not loaded

[SGaist]

Hi,

Start your application with QT_DEBUG_PLUGINS environment variable set to 1 so see what happens when the plugins are loaded.

You can set that variable in the Run part of the Project panel.

[JonnyQB]

@SGaist
where should i set it it =1

[JonB]

@JonnyQB
Did you see:

@SGaist said in cannot Excecute query in sql:

You can set that variable in the Run part of the Project panel.

[JonnyQB]

@JonB
@SGaist
like so ?
it changes nothing

[JonB]

@JonnyQB
Please take the time to read @SGaist's post; it's also in the Qt documentation. You have not spelled the environment variable as he typed, you have not used copy & paste, so what do you expect to happen if you do not get that correct?

[JonnyQB]

@JonB
i took time to read and figure it out but i couldnt find it because i think my qt is german soi dont know where to chage it exactly

[JonB]

@JonnyQB
To be clear: you are changing in the right place (I think!), but the name must be QT_DEBUG_PLUGINS, OK?

[JonnyQB]

@JonB
i changed it and got Error = "Driver not loaded Driver not loaded" again

[jsulm]

@JonnyQB With QT_DEBUG_PLUGINS set you should now get some additional output from the application. You have to check that output to see why the plug-in was not loaded (you can also post it here).

[JonnyQB]

@JonB @jsulm

[JonB]

@JonnyQB
We have said repeatedly what you need to set to get the debug output required in the replies above. Show us where you did what for that and we will look again....