I am writing a prototype program whose aim is to collect bookkeeping transactions in a Database ( Gadfly). After creating the table I create the variables with varAmount = StringVar() I then create labels in Tkinter to ease the input of data. With a function def treatment (): requete = "insert into transactions ( date,amount,,....) values(......) "% (varDate.get(), varAmount.get I transfer data from the labels in Tkinter into the Database at the end of the program with a button named "End" . I print the Database with print cur.pp(). No problem up to now but then I try to use a select command: cur.execute ("select sum(amount) from transactions").I get
Sum.amout.transaction ================= 100-10.5....... instead of 110.5 It means that the select command does not add but concatenates the different amounts. Why ? Many thanks if you can help me. Jean Moser -- http://mail.python.org/mailman/listinfo/python-list