在tkinterpython语句INSERT to SQLite with field Double data type中，不能隐式地将float转换为string

Question

在Tkinter中，Python 3.4 SQLite3：库塔配电箱真的

Tkinter声明：

cur.execute ( "INSERT INTO lista_clientes ( cuota, nit, nombre ) VALUES(" + lcuota.get() + "," + \
               + "'" + lnit.get() + "'" + ","  + "'" + lnombre.get() + "'" + ")" );
conn.commit()

lcuota = DoubleVar()

TypeError: Can't convert 'float' object to str implicitly

什么错误导致lcuota.get()？你知道吗

Answer 1

lcuota.get()返回float值，在将其与字符串连接之前，必须使用str(lcuota.get())将其键入字符串类型。你知道吗

试试这个：

cur.execute ( "INSERT INTO lista_clientes ( cuota, nit, nombre ) VALUES(" + str(lcuota.get()) + "," \
               + "'" + str(lnit.get()) + "'" + ","  + "'" + str(lnombre.get()) + "'" + ")" );