Search options (Page 1 of 2)

Good evening guys, I still haven't managed to reach my goal.
From the post that k245 published above, it is clear that Static Filters can only be inserted in the TV "Setting".
However, I would need a Dynamic filter on TV.
I have attached the latest test I carried out, but without obtaining the desired results. Even when I insert the filter, the application doesn't start.

For convenience I have also attached a screen shot, to see how I tried to link the filter to an ID box.

I also thought I could use one of these procedures
dbIndexToID
dbItemID
sqlvalue
, but I don't know how to implement the code.

A helping hand, thank you very much.

Hi Derek, thanks for the project, concise and effective.
I have a question about the project. How can it do instant search while you are typing something on Edit1 and Edit2. I was able to do this by creating a button like your "bsearch hidde", but I had to write a short script to make it work automatically. It seems like a native function of MDV.
Thank you

very clear,
thank you very much k245
I will use the filter directly from the TV settings.

Now it's clear.
Unfortunately, the logic is not explained clearly in the MVD guide, and the procedure for creating a basic model is also missing.
Thanks so much for the help guys.

Thanks so much Derek for your suggestions.  She will treasure it. 
_
1. Yes, better messagebox, mine was just an example for practice. 
_
2. In fact, I had noticed that it was starting to become difficult to manage the code, even with just a few pages, a more dynamic and easily adaptable code would be needed, I will take a look at your project as soon as I am in front of the PC.
_
3. It was a desired effect that I tested, just go to my code and uncomment the only commented line, you will see the tabsheet pop up.
_
4. I don't know how to embed Unicode icons, I think I will find the solution in your project.

So, is there a way to expand the MVD scheme?

Thanks k245.
I looked around the site a bit, you can see that there is a lot of work behind it.  I didn't quite understand what your first solution (first link) does, but I focused on the dynamic interface (second link).
_
It is a solution that I was looking for, especially because when working on different PCs, I find myself with rigid interfaces that do not adapt well to the different types of fencing both in terms of shape (4/3, 16/9 etc..) and resolution (Full HD , 2k, 4k etc...).
_
I think your dynamic interface, which works as a responsive theme for websites, is an excellent solution (perhaps the best).   
_
From the site, however, I didn't quite understand how to use your tool, or if perhaps there is a file to download to use it and adapt it to my application. 

Enlighten me. Thank you

I'm playing around with Derek's code a bit.
I can't figure out how to write the script to hide a TabSheet, using "Visible=False" method.
I'll post the code but it's definitely wrong.

procedure Form1_Button1_OnAfterClick (Sender: TObject);                   //** switch back to the 'customer list' tabsheet after saving the record
begin
  form1.PageControl1.ActivePageIndex := 0;
    form1.PageControl1.PageIndex1.Visible  := False; <--------- ERROR -------------
end; 

Hi Derek, Hi Brian,
Thanks for the replies.
The project is big, and so it must be, because I reconstructed the structure of a state software, and I needed all this data.
The need to have many FORMs arises from the fact that I had to create one for each piece of data I needed to insert, sometimes even just one piece of data, however for the FORMs I could also reduce their number, thanks to the solution identified by Derek in my last request "Open new page of a Page Control for New Record" can be reached here: https://myvisualdatabase.com/forum/view … p?id=8976.

The high number of tables arises from the fact that I had to build many different Combo-boxes. Brian's Solution seems workable though, (I had never explored the files), I tried it and it works great, so I can also manage the connections.

However, the graphical solution remains the most intuitive.
I had read a post in the Forum (damn, I can't find it anymore) it was titled something like this "three essential tools to use with My Visual Database", but I can't find it anymore, if anyone can give me a hand.

However I will continue to work on it. Thank you guys.