When I try to query records using Like in MySQL, QtSql returns false. With the same query in the database it works. What could be the problem?
db = QSqlDatabase.addDatabase("QMYSQL") db.setHostName("localhost") db.setDatabaseName("vista") db.setUserName("root") db.setPassword("Secret") if not db.open(): QMessageBox.critical(None, "Database Error", db.lastError().text()) query = QSqlQuery() query.exec_("SELECT * FROM vista.user WHERE fio LIKE '%Something%' ") self.tableSearch = QTableWidget() self.tableSearch.setColumnCount(query.record().count()) self.tableSearch.setRowCount(query.size()) i = 0 while query.next(): self.tableSearch.setItem(i, 0, QTableWidgetItem(query.value(0).toString())) self.tableSearch.setItem(i, 1, QTableWidgetItem(query.value(1).toString())) self.tableSearch.setItem(i, 2, QTableWidgetItem(query.value(2).toString())) self.tableSearch.setItem(i, 3, QTableWidgetItem(query.value(3).toString())) self.tableSearch.setItem(i, 4, QTableWidgetItem(query.value(4).toString())) self.tableSearch.setItem(i, 5, QTableWidgetItem(query.value(5).toString())) i += 1 self.tableSearch.show()
SELECT * FROM vista.user? - gil9redlastErrorto see if there were any errors while executing the request? - gil9red