Topic: create a form that contains database options?
Is it possible to create a form that contains database options?
the form appears at the beginning of the program,
as shown in the picture
My Visual Database → General → create a form that contains database options?
Is it possible to create a form that contains database options?
the form appears at the beginning of the program,
as shown in the picture
Perhaps this article will be useful for you to implement your plans.
SQLite database management
https://k245.ru/en/mvdb-en/sqlite-datab … ement.html
Hi Mousomar, Konstantin,
I offer a couple of options to two of your recent questions.
1. Database Options
Rather than try to select a single, physically different database (differentiated by year), would it not be easier (and offer a lot more flexibility by having the option to select more than just one year) if you just use a single database and differentiate 'years' logically by using a filter. This is far more straightforward and involves almost no coding (see 'choose database' in the attachment).
2. Selection criteria on a new form
I was puzzled why you seemed adamant that you wanted to use a separate form to hold your 'search criteria' (with all the extra coding that this would entail as well as being less 'user friendly'). Can't you simply put your 'search criteria' on the same form but use a panel rather than a separate form - again, it achieves (I believe) what you are trying to do but without any extra coding (see 'filter' in the attachment - click on the 'search' button to reveal / hide the panel).
As a general comment, I think that even those of us who are a bit more experienced using MVD, still try to play to its strengths and I suggest you try and do likewise.
Derek.
Hi Derek, Константин
Thank you k245
Thank you derek The Savior
Thank you verry much sparrow. This is what I was looking for.
Hi Derek, Константин
How simple and effective! Another gem in the collection. And as it often happens - undocumented, because the author of My Visual Database always answered that to change the base it is necessary to reboot the program.
Привет Константин
Дмитрий писал про эти команды в русской ветке. https://myvisualdatabase.com/forum/view … hp?id=4880
А этой ссылкой я удивлю вас ) - https://myvisualdatabase.com/forum/view … hp?id=8377
Я лишь попробовал их использовать таким образом, как пример.
Что касается перезагрузки? Я думаю что все зависит от времени и места где выбирается база данных.
Если вначале, при старте, наверное это допустимо ссылаясь на Дмитрия.
Если непосредственно во время работы, то возникает много вопросов и тут уже нужно серъезно проверять как отработают кеши,
таблицы, деревья и т.д.. Как минимум прийдется использовать очистки и UpdateDatabase('').
И во избежании проблем с базами я бы не рискнул в серъезной работе это делать на ходу.
Всегда можно приаттачить другую базу и вытянуть данные хоть и в ручном режиме.
Dmitry wrote about these commands in the Russian thread. I just tried to use them this way, as an example.
What about rebooting? I think that everything depends on the time and place where the database is selected.
If at the beginning, at startup, then it is probably acceptable, referring to Dmitry.
If directly during operation, then many questions arise and here it is necessary to seriously check how caches, tables,
trees, etc. will work. At the very least, you will have to use cleaning and UpdateDatabase('').
And in order to avoid problems with databases, I would not risk doing this on the go in serious work.
We can always attach another database and extract data, albeit manually.
Привет Константин
Дмитрий писал про эти команды в русской ветке. https://myvisualdatabase.com/forum/view … hp?id=4880
А этой ссылкой я удивлю вас ) - https://myvisualdatabase.com/forum/view … hp?id=8377
Я лишь попробовал их использовать таким образом, как пример.
Что касается перезагрузки? Я думаю что все зависит от времени и места где выбирается база данных.
Если вначале, при старте, наверное это допустимо ссылаясь на Дмитрия.
Если непосредственно во время работы, то возникает много вопросов и тут уже нужно серъезно проверять как отработают кеши,
таблицы, деревья и т.д.. Как минимум прийдется использовать очистки и UpdateDatabase('').
И во избежании проблем с базами я бы не рискнул в серъезной работе это делать на ходу.
Всегда можно приаттачить другую базу и вытянуть данные хоть и в ручном режиме.Dmitry wrote about these commands in the Russian thread. I just tried to use them this way, as an example.
What about rebooting? I think that everything depends on the time and place where the database is selected.
If at the beginning, at startup, then it is probably acceptable, referring to Dmitry.
If directly during operation, then many questions arise and here it is necessary to seriously check how caches, tables,
trees, etc. will work. At the very least, you will have to use cleaning and UpdateDatabase('').
And in order to avoid problems with databases, I would not risk doing this on the go in serious work.
We can always attach another database and extract data, albeit manually.
Всего два года прошло, но я уже не помню этой истории... а всё потому, что сразу не попробовал то, что предложил Владимир. И не прошерстил форум на предмет первоначального решения от Дмитрия... эх, старость - не радость...
По теме - да, есть нюансы с переключением на горячую, попробовал на большом проекте, с выполнением UpdateDatabase() чтобы комбобоксы на формах редактирования перезагрузились - выкидывает AV. А вот ваш вариант выбора при входе - нормально работает.
There are nuances with switching to hot, tried on a large project, with the execution of UpdateDatabase() so that the comboboxes on the editing forms are reloaded - throws out AV. But your option for choosing when entering - works fine.
Perhaps this article will be useful for you to implement your plans.
SQLite database management
https://k245.ru/en/mvdb-en/sqlite-datab … ement.html
Please send the sample file here. Thank you.
Please send the sample file here. Thank you.
Archive containing the latest version of the source code.
https://drive.google.com/file/d/1OeE9le … sp=sharing
The entire cycle of description of this project:
https://k245.ru/en/tag/data-keeper-en
milworm wrote:Please send the sample file here. Thank you.
Archive containing the latest version of the source code.
https://drive.google.com/file/d/1OeE9le … sp=sharing
The entire cycle of description of this project:
Thank you very much ![]()
My Visual Database → General → create a form that contains database options?
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi