about grid.delete()

[xubin983010]

my dear friends, I'm a new developer in nicegui. Seeking advice from everyone. When using ui.button('查询', on_click=on_button_click), the first execution of grid.delete() works fine, but it throws an error from the second time. Here is the hints:

File "e:\pyapp\nicegui_analysis\test6.py", line 46, in on_button_click
    grid.delete()
  File "C:\Users\Administrator\AppData\Roaming\Python\Python311\site-packages\nicegui\element.py", line 481, in delete
    self.parent_slot.parent.remove(self)
  File "C:\Users\Administrator\AppData\Roaming\Python\Python311\site-packages\nicegui\element.py", line 473, in remove
    self.client.remove_elements(element.descendants(include_self=True))
  File "C:\Users\Administrator\AppData\Roaming\Python\Python311\site-packages\nicegui\client.py", line 314, in remove_elements 
    del self.elements[element.id]
        ~~~~~~~~~~~~~^^^^^^^^^^^^
KeyError: 34

here is my code,ths for your helping.

from nicegui import ui
import pandas as pd
from Utils.db_mssql import db
from Utils.datetimepicker import DateTimePicker

title='Check Table'
id='59A62C21-6245-43B5-BE13-AD1700A0C2A2'
stime = ''
etime = ''
original_sql = f'''
SELECT e.factory, e.plant, e.name, e.code, e.CreateDate
    FROM Run_ExceptionRecord e
    WHERE DeviceID = '{id}'
'''

def getIeam(sql):
    conn = db.connect()
    result = db.query_data(conn, sql)
    db.close(conn)
    return result
def on_button_click():
    global stime, etime
    stime = date_time_picker1.get_datetime()
    etime = date_time_picker2.get_datetime()
    print(f'Selected Date: {stime}-{etime}')  
    if stime =='error' or etime =='error':
       pass 
    else:
        sql = original_sql + f" AND e.CreateDate BETWEEN '{stime}' AND '{etime}' ORDER BY e.CreateDate DESC"        
        df = pd.DataFrame(data=getIeam(sql))
        grid.delete()
        table = ui.table.from_pandas(df)
    

with ui.row().classes('items-center justify-center'):
    ui.label('选择开始日期和时间').classes('w-12 text-md font-bold')
    date_time_picker1 = DateTimePicker()
    ui.label('选择结束日期和时间').classes('w-12 text-md font-bold')
    date_time_picker2 = DateTimePicker()
    ui.button('查询', on_click=on_button_click)
    
with ui.grid(columns=16).classes('w-full') as grid:
    ui.label(title).classes('col-span-full text-center size-50 bold margin-bottom-10')
    ui.add_head_html('''
    <style>
        .center-row {
            display: flex;
            justify-content: center;
            align-items: center;
        }
    </style>
    ''')
    with ui.row().classes('center-row col-span-full'):
        df = pd.DataFrame(data=getIeam(original_sql )) 
        table = ui.table.from_pandas(df)
ui.run()

[python-and-novella]

Because grid is deleted. You can't delete again.

[xubin983010]

thanks.

[xubin983010]

Because grid is deleted. You can't delete again.

By clicking button,I want to update tablet data.Is there any good way to do it?thanks

[python-and-novella]

The discussion is close, you 'd better create a new one.
BTW, if you are beginner of nicegui, you should learn document carefully before coding.
ui.table | NiceGUI
https://nicegui.io/documentation/table

[python-and-novella]

Don't ask every problem when you met.
Plz try your best to learn document and solve problem, then ask for help.