1. Vladimir Esipov
  2. Valentina Studio
  3. Wednesday, September 11 2024, 12:27 AM
  4.  Subscribe via email
When both tables are open in the data editor - parent and child - continuous movement of the cursor row along the parent table causes unnecessary queries of the child table for each row in the parent table.

This leads to an increased load on the server in the case of a client-server configuration, and in the case of a local DB there is no need to load the processor in vain.
I think it makes sense to execute a query to a related table with a timer delay, i.e., only when the cursor along the parent table has stopped moving. In my programs, I do this - a query by timer after ~0.3 sec.

This is especially relevant in our difficult times, when all progressive humanity is actively fighting for energy conservation (as well as with global warming / cooling, pandemics / stomach cramps and other misfortunes on schedule). :)
I think it makes sense to implement this - and Greta Thunberg will be happy!
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Vladimir,

Thank you, it's a good idea.
Comment
There are no comments made yet.
Vladimir Esipov Accepted Answer
At the moment, when working with a table in the Data Editor, when you click on a row with the mouse, the field in the row goes into immediate editing mode.
This is not always convenient if I just want to view the data in this or a related table. Now, after clicking in the editor, I have to remember to press the ESC key to exit the editing mode. I accidentally erased data several times, and since there are no transactions and you can't roll back - sit and think later about what was written there...
Is it possible to add an option in the Preferences panel for the Data Editor - Immediate editing mode (True / False).
In order not to change the behavior that is already familiar to users, it is enabled by default. If this flag is unchecked, when you click with the mouse - simply set the focus to the specified cell, without switching it to editing mode.
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Yes, thank you, we'll add it
Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories