Basic Qt Sql Question

[norobro]

Try "qry.lastError().text()" @ line 39 in lieu of "db.lastError().text()"

[sidenelen]

now the error changes like:

error = "near "1": syntax error Unable to execute statement"

[Lykurg]

What wysota was trying to say to you is: You are using the wrong database driver for MySql. This is most probably also the reason why the query throws an error. Not all database systems understand the same SQL commands.

[wysota]

now the error changes like:

And if you correct the syntax? Does it work then?

[Lesiok]

Yours SQL query is bad

SELECT * FROM `tablo` 1

SELECT * FROM `tablo` 1

To copy to clipboard, switch view to plain text mode 

It should be

SELECT * FROM `tablo`

SELECT * FROM `tablo`

To copy to clipboard, switch view to plain text mode 

or

SELECT * FROM `tablo` WHERE 1

SELECT * FROM `tablo` WHERE 1

To copy to clipboard, switch view to plain text mode 

Of course, the latter figure does not make sense.

[sidenelen]

@Lesiok
Yeah, I corrected the code as you said and it works! Thank you all guys