1

(5 replies, posted in General)

Thank you all for the reply here!

Yeah- at times, I like to randomly browse through the forum posts.  Most likely it was one that was not so recent, so I will probably not stumble across it again- it seems (because my browser history is also cleared often).

The request was a shot in the dark at best, and I was hoping that my discription would trigger (maybe the creator) someone else's memory of it.  I appreciate your replies all the same.  And I apologize to any others for the wasted time reading it.


vladimir, I will have to review that one... it may acheive the same thing that I was interested in.


EDIT: derek, lol, yea sorry about that...  but I view so many of your projects that they have all become blurred in my memory now. lol  And yes, I thought it would have been one of his too, but- I have reviewed all of his from this year without luck.

-joshuA

2

(5 replies, posted in General)

Hello MVD friends,

This is an unusual request...  Within the last few weeks or so, I stumbled upon a useful project that I forgot to save.  I want to say that it was one that derek uploaded, but I could be wrong.

I remember the way the forms looked, and that's about it.

I have searched the forum in many different ways for an hour or so trying to locate it.  So, I thought I would post and describe what I remember about it in hopes that someone else may remember more about it and where it may be.


It was a service type project storing dates for certain types of equipment.  And depending on which type of equipment it was, only a certain page was visible from a page control.

It seems like there was a hydraulic and electronic page and also another that I don't remember.  Each page had at least two date fields and maybe some other fields.

The thing that stood out to me is how the database was structured.  It had all the date fields together on a single table.  So some of them would be null when that entry didn't need that type of service.


The problem is I don't know what the topic question was and the terms that I could think of are so broad that it returns too many results.

I am not expecting anyone to help me search for this, but rather if someone that was involved in that thread recognizes the description above, I would greatly appreciate if they would respond.

-joshuA

Thank you for sharing this Derek.  I have wondered how (and if) this could be done big_smile

pavlenko.vladimir.v wrote:

Теперь можно даже имена складам выдавать..

Impressive vladimir!  Thank you for this example.

5

(8 replies, posted in Talks about all)

k245 wrote:

[я хочу сделать подарок для всех разработчиков, которые уже используют или будут использовать My Visual Database: бесплатный доступ ко всем моим статьям, книгам и файлам с проектами, которые находятся в Библиотеке визуального программирования

Thank you greatly for your excellent work and documentation!!!  It is truly astonishing.  :salute:

Would you happen to have a translated copy available?  I just wanted to ask before I run it through Google translate wink

6

(6 replies, posted in General)

Hi blackpearl,


I second your post title!  Unfortunately, we haven't seen any signs lately...


-joshuA

7

(35 replies, posted in General)

Hi vovka,

vovka3003 wrote:

Наверное не все пробовали...

Yeah- sadly, I have not done so.
Да, к сожалению, я этого не сделал.
.
Thanks for sharing that demo.  It is second on my list- especially since there are English translations.
Спасибо, что поделились этой демонстрацией. Он стоит вторым в моем списке - тем более, что есть перевод на английский язык.

-joshuA

Hello again Derek,

No problem with your understanding of how the parent combobox function should be used.

Thanks for clarifying this for me.  I have a habit to second guess myself on these things.  This happened to be one of those exceptions where it wasn't the way to handle what I was after though.
.
I was a bit surprised that no one else has asked this before (at least that I could find).

I much prefer the way that Sparrow used to built it (using combobox.dbfilter) - my way seems rather verbose.

While I agree, I will consider any way that someone is generous enough to suggest- no matter how verbose big_smile
I have learned to always try and let MVD do as much as possible- whenever I am aware of it.  And the dbfilter is one of the things I was referring to above.  I am going to study this approach a bit further for future situations.  Another hidden gem- I'm sure!
.
I did like the way you set focus and added the auto dropdown for the address selection.  Now I have to decide which one to use lol
.
Glad to hear the sample was helpful too- there are some nifty data generators out there.

-joshuA

Derek, I didn't include any of the save stuff in the projects because I was focused on the comboboxes.  Sorry for not clarifying that.
.
So, you both do away with the parent combobox.  Maybe I was using them inappropriately here...
.
Sparrow, I was trying to let the program not only deal with queries, but also with populating the parent child stuff too- oh well.
.
There were techniques in both of your solutions that I hadn't seen, so thank you both for that.
.
Once again, many many thanks to you both!
-joshuA

Greetings fellows!
.
I was hoping someone could offer some ideas- as I was unable to find anything on the forum.
.
Here is the situation:

I have two comboboxes and one is a parent.  After the parent (customer) item is selected, WHEN there is only a single (address) child item, I wish for it to be selected automatically by default.  Otherwise, the user will select a desired choice from the multiple items.
.
This is a minor issue, but it would make one less click for user entry lol
.
I have tried many different things, but I am not familiar enough with the order that the OnEvents occur to get the desired result.

  • Manually clicking the button - works as desired

  • OnCloseUp - Doesn't work at all

  • OnChange - Works, but then it unsets the item from the combobox

  • OnClick - Same as above (seems to work better than the others however)

.
I noticed the OnChange seems to click the button twice, perhaps this is because of the child.DoOnChange though...
.
Other things I tried:

  • using DbItemID instead of ItemIndex.  Which is how I have been setting combobox values in the past...

  • changing the DefaultIndex value for the child combobox.

My guess is that this has something to do with the behavior of the parent and child comboboxes.  Or maybe there is a better way?
.
NOTE: In addition to removing the .exe file, I also removed the sqlite.dll because it was over 1MB in each folder and the forum said the file was too large.
.
I appreciate anyone taking a look.
-joshuA

11

(35 replies, posted in General)

reteinformatica wrote:

Where can it download DataExpress?

Funny enough K245 just posted that link in another thread earlier over here


Hi Derek, thanks also for sharing your thoughts on this too.  I don't see any need to switch to another alternative for MVD.  However, I do browse out of curiosity from time to time.
.
I totally agree, and I was thinking about that just earlier today actually.  It is rather mind boggling at how Dmitry has created such an exceptional tool.  Nothing that I have used has even come close to its simple efficiency packed with such potential.
.
A year or so ago, I had a slight concern about the newer versions of windows being an issue.  It is reassuring to know that some of you are still going strong even on those platforms too.
.
Going between 7 and 10, 11- I had noticed a few minor quirks with certain control properties being slightly different (such as colors not being recognized).  I'm sure this will slowly get worst over time as MS continues making these unnecessary changes to windows.  Bah!
Edit: added
To specify what I was referring to about "certain control properties i.e. colors not being recognized" was the combobox.
Using Windows 7, the BgColor property can be set
Using Windows 11, in order to set BgColor, the Searchable property must also be set to true
.
I am probably one of the few that even cares about this lol  but I use it occasionally
End edit
.
And yes, the members of this forum are also the other part that make it so great!  Thank you all for that!
.
-joshuA

12

(35 replies, posted in General)

Greetings!

But we can always dream of it.

I am with you...

I looked at this alternative projects.

Nice comparisons K and thank you.  That DataExpress seems like a clone of MVD lol

13

(27 replies, posted in General)

Wow, those look nice from the 10+ notepads.  That explains it because I still use Windows 7 often.


sparrow: thank you for responding-  Unicode seems to be a moving object, thanks for the extra detail.  It may be possible to update on Windows 7, haha


Thanks again
-joshuA

14

(27 replies, posted in General)

Greetings all,

Nice thread!

derek wrote:

I just collect a list of the ones that I'm likely to use and save them in a .txt file for quick access (see attached).  And as I find a new symbol that I might need, I simply add it to the .txt file.
Derek.

I like the idea of the symbols for button icons.  I know this is your personal collection derek, but some of them do not render properly for me.  I am guessing these are font specific.

I tried viewing it in both Notepad2 and Notepad++ and also pasted them into Word.


Which editor do you normally use?  And would you share the settings to get them to display properly?


I also get the same result pasting them into MVD.

-joshuA

Hi sparrow,


This is precisely what I was missing, great!  Thank you very much.


-joshuA

Hi Derek,


Yes- I'm still around... mostly observing.  Until I had this curious question that is. lol  Nice to see the veterans still hanging around!


I forgot to mention that this was a simplified version of a larger project...


It comes from showing details from other tables related to a product during selection.  Or also, to allow a filter by (category, or description) from many products.

The model I was using came from one of ehwagner's projects.


Even though I'm able to get this working (via script), I was just curious about the parentcombobox property.  It seems there is something happening internally when the parent is manually selected.  And so, I had even tried dbItemUpdate on the comboboxes.


Aside:
It seems common in an order, orderDetail case for the detail records to copy values from a lookup.  I suppose this is to capture a historical snapshot for an order (in the event that item names change or get removed, etc.).  Though, I am not completely sure about this.


Thank you for having a look,
-joshuA

Hello all,


I have a curious question about this parentcombobox behavior.  I am able to solve this using a script, but I was wondering if it could be done otherwise.


Description:

The orderitem has a lookup form to select a product from a tablegrid.  Once a product has been selected, that ID is copied to a "parent" combobox, but the child combobox is not populated (unless the parent is manually selected).  But, it needs to be hidden from view.


So, my question: why doesn't setting the parent dbItemID work?  (Apparently there is something missing from when it is being manually selected.)


-joshuA

18

(24 replies, posted in Reports)

Hello unforgettable,

There is a built-in function in MVD called toWords.  There are quite a few threads with that search. Maybe this will help you get started.

19

(4 replies, posted in General)

Hi all,

If somebody has a good alternative ER Diagram Designer he can also answwer here.

I would recommend trying http://draw.io/ which is interestingly last on the list in the link that brian provided.  It is useful for other things besides ERDs too.  It is easy to remember the name, it provides a web interface and also a downloadable software version (if preferred).


It doesn't do any automatic stuff, so one of the others in that list may be better suited for you.


Thanks for sharing the link too brian.


-joshuA

20

(9 replies, posted in General)

Hi everyone,

Thank you all for sharing these different methods for this common task.  We will have to rely on such methods...

-joshuA

21

(1 replies, posted in General)

I second this notion.


Also, here are related links:


Legacy projects represent code that continues to provide value long after being written. You want to maintain these legacy projects, adding new features as needed, and be sure they continue to work on new platforms now and in the future. That's where this webinar comes in. Evaluate the risks of redesigning vs. rewriting your legacy project. Learn the best approaches to refactoring while minimizing the risk of rework by making your code testable and adding test coverage. Join Jim McKeeth as he interviews Bill Meyer, author of Delphi Legacy Projects: Strategies and Survival Guide for this webinar all breathing new life into your living legacy.


Наследие проекты представляют собой код, который продолжает обеспечивать ценность еще долго после написания. Вы хотите поддерживать эти устаревшие проекты, добавляя новые функции по мере необходимости, и убедитесь, что они продолжают работать на новых платформах сейчас и в будущем. Вот где вступает этот вебинар. Оцените риски перепроектирования против переписывания вашего устаревшего проекта. Изучите лучшие подходы к рефакторированию при минимизации риска переделки, делая ваш код тестируемым и добавив тестовый охват. Присоединяйтесь к Джиму МакКэту, когда он берет интервью у Билла Мейера, автора книги Delphi Legacy Projects: стратегии и руководство по выживанию для этого вебинара, все вдыхая новую жизнь в ваше живое наследие.

22

(6 replies, posted in General)

Derek,
Yeah- I can relate to that, but I still had to ask out of curiosity.
I appreciate the responses.
-joshuA

23

(6 replies, posted in General)

Hi Derek,

No, I do understand the difference between the two points you mention.  But thank you for asking anyway.  And I do require both as you describe them.

My concern is more centered on what is happening to the data inside of MVD.  And I guess, my lack of experience is part of the cause here.  Example 2 kinda hints at this, because I checked for specific role(s) in the logic- even though the tab is hidden using the same condition (just to be certain).

But I am starting to feel at ease with my approach now since you say there are several ways it can be done.  So, thank you for that.


On another note, while you're in here... I was curious as to why you used a form label, in your earlier project, instead of the key being hard coded?

I've also been considering ways to make the key something that can be maintained by the user(s) as well.  I have a few ideas about it, but I haven't gotten that far yet.

-joshuA

24

(6 replies, posted in General)

k245,

Thank you for your response.

I didn't really have a specific question.  I was kindly just asking for any feedback about my approach- which you provided.  Thanks for the example, I hadn't thought about doing it that way.

However, I guess I was touching on the concern about encoding-decoding unnecessarily, which your example handles that nicely too.

-joshuA

25

(6 replies, posted in General)

Hi folks,


I am working on a feature for one of my projects.  So, I created a sub-project to explore the behavior that I had in mind.
I came across one of derek's projects that almost covers it.  Except, I also wanted to use roles with it.


Example-02
This is what I came up with initially.  (Which is one way it could be done if lower level users are to access all the tabs)


Example-03
If I rely on using role-access to hide the tabSheet containing the encrypted fields, I could simply eliminate all of the en/decryption logic.


users:passwords
admin:a
user:u


I would appreciate any thoughts.

-joshuA