Search options (Page 5 of 60)

project

You can add a calculated field and use it in a dropdown list.

Пишите, договоримся ))

It is unlikely that there will be a psychic here who can help you without seeing your project )

I observed problems with column width in two cases: during the first launch and when the program crashed.
As for intelligent alignment of column widths, you can’t do without scripts. I agree that in some cases the proposed alignment options look good, but firstly, they provide an additional delay when displaying data, and secondly, they are not always convenient, so this, perhaps, can be done as an option in the grid settings through the pop-up menu. Thanks for the tip, I'll probably add such an option in the next version of Data Keeper.

For large data sets, I abandoned the combobox,

replacing it with two components: an input field (to display the selected value) and a button (to display the reference form). Of course, you will need scripts, examples of which can be found in this project.
https://k245.ru/en/mvdb-en/light-filtered.html

Light filtered

It’s cool November outside, so this article will not be about a refreshing drink in the summer heat, but about the filtering mechanism in the Data Keeper project, as a result of which we should receive filtered data. Of course, they will only be light if you use a light theme for the application.
https://k245.ru/en/mvdb-en/light-filtered.html

У меня работает со стилями без проблем. см. проект ComponentExplorer
https://k245.ru/software-ru/is-ru/rukov … chika.html

The appearance of the TProgressBar component starting from Windows 7 is determined by the operating system settings. But if you use style, then the progress bar becomes stylish too.

Светлое фильтрованное

Data Keeper - автоматическое построение панели фильтрации объектов заданного класса на основании списка свойств.
https://k245.ru/mvdb/svetloe-filtrovannoe.html

In this case, it is necessary to add a check before deleting an entry: if the entry being deleted is referenced as a manager, then report this and not allow deletion.

There may be several options: 1) do not delete; 2) reset the link in dependent records to NULL; 3) delete along with dependent records. In your case, the first or second option will be suitable.

In real systems, records are rarely deleted unless they were entered to test the system. Typically, flags are used to indicate that the entry is being archived and should not be displayed in normal cases.

But your case is even more interesting. I would add a separate table - managers, which would link to the employees table. In this case, when dismissing or changing a manager, you do not need to edit all the employees who linked to him, but rather make one edit in the manager table, linking it with another person or with a special record, where instead of the first and last name it will be written “Position vacant”

Вы можете сделать два приложения, если так вам проще. Но не делайте две базы, настройте подключение базы через настройки параметров. А чтобы информация обновлялась в "клиентском" варианте прямо в процессе работы, добавьте кнопки обновления таблиц или делайте обновление по таймеру.