Re: tkinter: tksheet

2021-06-17 Thread Rich Shepard
On Thu, 17 Jun 2021, Dennis Lee Bieber wrote: FreePascal/Lazarus is supposed to be similar to Delphi, and does have Linux installs -- but I don't know what it provides for database linkages. I do have it installed on my Windows box (the Linux install is HUGE; takes up over 1/4 of the spa

Re: tkinter: tksheet

2021-06-17 Thread Rich Shepard
On Thu, 17 Jun 2021, Alan Gauld via Python-list wrote: Sounds like a job for a database view. Can you modify the database schema? Could you create a view - even a temporary one just while your app is running? Alan, Yes, created views work well with postgres. Building one for complex, multitab

Re: tkinter: tksheet

2021-06-17 Thread Rich Shepard
On Thu, 17 Jun 2021, Dennis Lee Bieber wrote: My naive idea is to use two queries, one selects * from the company table ordered by nunber, the other by name. The UI offers two radiobuttons when viewing the results, one for each sort column. Presuming all the data fits in memory, it may

Re: tkinter: tksheet

2021-06-17 Thread Alan Gauld via Python-list
On 17/06/2021 00:15, Rich Shepard wrote: > When I view my contacts table it needs to includes attributes from the > company, people, and contacts tables so I can view all prior contacts with > that person. Sounds like a job for a database view. Can you modify the database schema? Could you create

Re: tkinter: tksheet

2021-06-16 Thread Rich Shepard
On Wed, 16 Jun 2021, Alan Gauld via Python-list wrote: But there is nothing I know of for Tkinter that provides views of database tables in the way that Delphi or VB or C# do, for example. Alan, These are all Microsoft tools. I run linux only. You have to extract the data using SQL and popu

Re: tkinter: tksheet

2021-06-16 Thread Rich Shepard
On Thu, 17 Jun 2021, dn via Python-list wrote: Use the DBMS by retrieving the data in the desired sequence? dn, Yep. That's what I thought would be the best approach. Thanks, Rich -- https://mail.python.org/mailman/listinfo/python-list

Re: tkinter: tksheet

2021-06-16 Thread Rich Shepard
On Wed, 16 Jun 2021, Dennis Lee Bieber wrote: Scroll further down to "bindings"... rc_insert_row -- a menu binding Dennis, Yes, I saw that one, too. As for sorting, I don't see anything that allows one to add custom events to the bindings... best I can come up with is that

Re: tkinter: tksheet

2021-06-16 Thread Alan Gauld via Python-list
On 16/06/2021 21:45, Rich Shepard wrote: > The two applications I'm building are both database applications. If > tksheet() is not the most appropriate widget to display database tables what > alternative would be better? I've not used tksheet but it sounds like it might be worth investigating.

Re: tkinter: tksheet

2021-06-16 Thread dn via Python-list
On 17/06/2021 08.45, Rich Shepard wrote: > On Wed, 16 Jun 2021, Terry Reedy wrote: > >> Somewhat sparse doc at >> https://github.com/ragardner/tksheet/blob/master/DOCUMENTATION.md#5-modifying-table-data >> >> insert_row() > > Terry, > > I'm reading this now and saw that. > >> and change the col

Re: tkinter: tksheet

2021-06-16 Thread Rich Shepard
On Wed, 16 Jun 2021, Terry Reedy wrote: Somewhat sparse doc at https://github.com/ragardner/tksheet/blob/master/DOCUMENTATION.md#5-modifying-table-data insert_row() Terry, I'm reading this now and saw that. and change the column used for sorting (e.g., sorting by company number or company

Re: tkinter: tksheet

2021-06-16 Thread Terry Reedy
On 6/16/2021 12:31 PM, Rich Shepard wrote: Reading the doc for tksheet tells me that it allows me to modify cells (or entire rows) as well as display them. What I don't see is whether I can add a new row using tksheet Somewhat sparse doc at https://github.com/ragardner/tksheet/blob/master/DOCUM

tkinter: tksheet

2021-06-16 Thread Rich Shepard
Reading the doc for tksheet tells me that it allows me to modify cells (or entire rows) as well as display them. What I don't see is whether I can add a new row using tksheet and change the column used for sorting (e.g., sorting by company number or company name). If you have experience with tksh