sqlite Sql语句只返回布尔值

zbwhf8kr  于 2023-01-13  发布在  SQLite
关注(0)|答案(1)|浏览(172)

我想用数据库中的personalids填充组合框“Box_personal”,但它只返回“true”。

def kombobox_fuellen(self):
    result=[]
   abfrage = "SELECT DISTINCT(Personalnummer) as Personalnummer FROM mitarbeiter"
    result = query.exec(abfrage)
    my_list = [r for r, in result]
   self.Box_personal.addItems(my_list)

我也试过,它打印出所有的个人号码,但添加每一个单一的数字作为自己的条目到框中

def kombobox_fuellen(self):
    # SQL Abfrage aller daten
    result=[]
    abfrage = "SELECT Personalnummer FROM mitarbeiter"
    query.exec(abfrage)
    while query.next():
        result = str(query.value(0))
        print(str(result))
    # self.Box_airline.addItems("")
        self.Box_personal.addItems(result)
7vux5j2d

7vux5j2d1#

我犯了一个小错误,下面是代码,它现在运行:

def kombobox_fuellen(self):
    # SQL Abfrage aller daten
    abfrage = "SELECT Personalnummer FROM mitarbeiter"
    query.exec(abfrage)
    while query.next():
        result = str(query.value(0))
        print(str(result))
    # self.Box_airline.addItems("")
        self.Box_personal.addItem(result)

问题是addItems -〉更改为addItem和wolla

相关问题