57','Berlin','12209','Germany') INSERT INTO Customers VALUES(2,'Ana Trujillo Emparedados y helados','Ana Trujillo','Avda. Sql = """ DROP TABLE IF EXISTS Customers CREATE TABLE Customers ( CustomerID INTEGER PRIMARY KEY AUTOINCREMENT, CustomerName TEXT, ContactName TEXT, Address TEXT, City TEXT, PostalCode TEXT, Country TEXT ) INSERT INTO Customers VALUES(1,'Alfreds Futterkiste','Maria Anders','Obere Str.
#ENTRY ICURSOR HOW TO#
It would require some thinking to decide the exact behavior desired and figure out how to accomplish, and we'd need to change the info-popup to use asyncio. Got it somewhat working with force-save, and disabling the threaded info close. Basically it creates an input box, and sets it in front of the table cell. Playing around with PySimpleGui editable-table example.
#ENTRY ICURSOR CODE#
Either need to prompt_save() or something? Maybe after sorting, before updating selector, replace current row with changed_rowįinal cleanup, put functions in correct spot, minimize code duplication. Sort() currently reverts table element, since it updates directly from rows. Rename save to save_cell - Made ACCEPT/CANCEL, like excel/libreoffice Autosave would have an X button to discard. I think behavior should be: autosave or auto-discard. Current has save/discard buttons, click outside of widget discards. Rename Dataset.changed_row to? MOVED INTO rows.attrs
In example I posted it originally stretched too wide. Make sure I’m getting current row correctly, and sorting the table doesn’t break it.Īdd save/discards to themepack, to either enable or disable. Change to name, so that sg.Table can have different column positions and still work I think I’m saving changes into changed_row using col position. Make sure Dataset.changed_row resets properly in all save conditions. Possibly bind field elements to push changes to sg.Tables on unfocus edit.
#ENTRY ICURSOR UPDATE#
In records_changed, add logic to see when Table element has changed, and use that for database update instead of elements.įinal _CellEdit cleanup: Pass more variables around instead of using class self variables. If we push changes to field elements, then we can check field elements against changed_row (if it exists) instead of getting copy directly from rows. Push Table cell change to field elements, if there are any Put ("", callback) in Form.bind routineĪdd edit_enable=True to TableHeaders (does this change what we call TableHeaders?) New: update_actions, update_fields.īind ("", self.discard()) to destroy the edit window if user clicks anywhere else other than edit-field/buttons. IN PROGRESS - clean up initial port into single class
Initial port into pysimplesql: Move logic into _CellEdit Use tk.after() for delay live update on text entryĮxpand live update to slider, radio buttons, and listboxĭon’t update other dataset combo boxes when a description_column, if row is virtualĬreate new Relationship function that returns data_key : column of all dependent columns (that are foreign keyed to the updated column, but arnt cascade dependent.Īnd another uses above to see if the description column used in dependent so.Table TableHeadings col list
0 kommentar(er)
