• sara55

    It works, thank you very much

    posted in Pythonista read more
  • sara55

    Thanks, I will try

    posted in Pythonista read more
  • sara55

    Hi,
    I would like to get input from ui.textfields and. Insert the data into SQLite DB.
    I have used a button action to read the fields and insert to the DB.Is there a better way of doing it without the button?

    import ui
    import sqlite3
    
    def button_action(sender):
        #con = sqlite3.connect(":memory:")
        conn = sqlite3.connect('jubk.db')
        #con.isolation_level = None
        c = conn.cursor()
    #   c.execute('''CREATE TABLE emploee_db3 
    #       (id_num text, first text, last text)''')
        first = first_name_f.text
        last = last_name_f.text
        id_num = id_num_f.text
        print('first name ', first, 'last name ', last, 'id ', id_num)
        
        c.execute("INSERT INTO emploee_db3 VALUES (:id_num, :first, :last)", {'id_num': id_num, 'first': first, 'last': last})
        for row in c.execute('SELECT * FROM emploee_db3'):
                    print(row)
        conn.commit()   
            
    v = ui.load_view()
    v.present('sheet')
    
    first_name_f = v['first_f']
    last_name_f = v['last_f']
    id_num_f = v['idnum']
    

    posted in Pythonista read more
  • sara55

    Thank you very much

    posted in Pythonista read more
  • sara55

    Thanks, it worked.
    How would I load a JPG image ?
    Img = ?

    posted in Pythonista read more
  • sara55

    Thank you very much, I will try.

    posted in Pythonista read more
  • sara55

    I am new to python and Pythonista.
    I would like to save ui.image and not create it very time from JPEG.
    Is it possible?

    Thanks

    posted in Pythonista read more

Internal error.

Oops! Looks like something went wrong!