Whats the problem with this? if i enter wrong ID key error not showing up
-
you did not read/understand how to use prepare correctly?
self.query = QSqlQuery() self.query.prepare("select * from incoming_mac_records where ID=?") self.query.addBindValue(self.search.text()) if not self.query.exec(): print self.query.lastError() else: while self.query.next(): #do whatever you need to do@the_
search = self.search.text()self.query = QSqlQuery() self.query.prepare("select * from incoming_mac_records where ID =?") self.query.addBindValue(search) if not self.query.exec_(): print self.query.lastError() else: while self.query.next():if the ID key is active it show the print statement "active" but if not existing the self.query.lastError() not showing up
-
@the_
search = self.search.text()self.query = QSqlQuery() self.query.prepare("select * from incoming_mac_records where ID =?") self.query.addBindValue(search) if not self.query.exec_(): print self.query.lastError() else: while self.query.next():if the ID key is active it show the print statement "active" but if not existing the self.query.lastError() not showing up
@Aquarius171 I already told you two times that QSqlQuery::exec() does NOT fail if the id is not found! Do you actually read what others write?
exec() only fails if your query is invalid (wrong SQL syntax) or there is no database connection. If the id is not found exec() will not fail (this is now the third and last time I tell this, sorry, but you really should read answers) - it will execute successfully and the result will be an empty table. A SQL SELECT statement NEVER fails if it does not find anything, instead it returns an empty result. -
@Aquarius171 I already told you two times that QSqlQuery::exec() does NOT fail if the id is not found! Do you actually read what others write?
exec() only fails if your query is invalid (wrong SQL syntax) or there is no database connection. If the id is not found exec() will not fail (this is now the third and last time I tell this, sorry, but you really should read answers) - it will execute successfully and the result will be an empty table. A SQL SELECT statement NEVER fails if it does not find anything, instead it returns an empty result. -
@jsulm for that thank you! and sorry :) GodBless sir ^_^ Have a nice day
@Aquarius171 No problem! It's just that it is sometimes annoying if you repeat the same several times but the questioner does not read or ignore your explanation :-)
One tip: if you only need to know whether the ID is used use
SELECT count(*) FROM incoming_mac_records WHERE ID =? -
@Aquarius171 No problem! It's just that it is sometimes annoying if you repeat the same several times but the questioner does not read or ignore your explanation :-)
One tip: if you only need to know whether the ID is used use
SELECT count(*) FROM incoming_mac_records WHERE ID =?@jsulm how do i display count?
-
@Aquarius171 No problem! It's just that it is sometimes annoying if you repeat the same several times but the questioner does not read or ignore your explanation :-)
One tip: if you only need to know whether the ID is used use
SELECT count(*) FROM incoming_mac_records WHERE ID =? -
@jsulm how to use isNull( int )?
Again: you did not read and/or understand the PyQT QSqlQuery documentation??
-
@jsulm how to use isNull( int )?
@Aquarius171 If you're asking questions then please explain better!
Where do you want to display count?
Where do you want to use isNull() and for what data? -
@Aquarius171 If you're asking questions then please explain better!
Where do you want to display count?
Where do you want to use isNull() and for what data?@jsulm thank you already figure it out Thank you and sorry again sir ! :)
-
Again: you did not read and/or understand the PyQT QSqlQuery documentation??
@the_ i am reading it now haha sorry bro
