Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- self.workCombo.setEditable(True)
- pFilterModel=QSortFilterProxyModel(self.workCombo)
- pFilterModel.setFilterCaseSensitivity( Qt.CaseInsensitive )
- pFilterModel.setSourceModel(self.workCombo.model())
- AutoComboCompleter=QCompleter(self.workCombo)
- AutoComboCompleter.setModel(pFilterModel)
- AutoComboCompleter.setCompletionMode(QCompleter.PopupCompletion)
- self.workCombo.setCompleter( AutoComboCompleter )
- self.workCombo.lineEdit().textEdited[unicode].connect(self.filtro)
- sql = "select * from T1 where rownum<201"
- self.workCombo.addItem(label,-1 )
- qry = QSqlQuery(myDB())
- if qry.exec_(sql):
- while qry.next():
- k, v = qry.value(1), qry.value(2)
- self.workCombo.addItem(v, k)
- def filtro(self,text):
- logMessage("text {} ".format(text))
- model = QSqlTableModel(self,self.plugin.gridDb())
- model.setTable("table(F_GETLISTOPTIONFORMI('P_CS_WORK',NULL))")
- stringa = "\"p_description\" like \'%"+text+"%'"
- #QtCore.QString("\"p_description\" like \"%%1%\"").arg(text)
- logMessage(" filtro {} ".format(stringa))
- model.setFilter(stringa)
- model.select()
- AutoComboCompleter=QCompleter(self.workCombo)
- AutoComboCompleter.setModel(model)
- AutoComboCompleter.setCompletionMode(QCompleter.PopupCompletion)
- self.workCombo.setCompleter( AutoComboCompleter )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement