Topic: Final version 4.3

Final version 4.3


Download: http://myvisualdatabase.com/download/myvisualdb.exe



What's new:
- Added component TreeView, project example: http://myvisualdatabase.com/forum/misc. … download=1
http://myvisualdatabase.com/forum/misc.php?action=pun_attachment&item=4149&download=0


- New functions:

GetFileCreationTime('d:\filename.jpg');
GetFileLastWriteTime('d:\filename.jpg');
GetFileLastAccessTime('d:\filename.jpg');


- Bug fixes.

Post's attachments

Attachment icon TreeView.zip 8.83 kb, 858 downloads since 2018-03-20 

Dmitry.

Re: Final version 4.3

Hello Dmitry,


I had a look at your new beta version, and what you added is not a treeview... this is a DBTreeView and THIS IS AWESOME !!!


Very very nice my friend, I love it !


From what I see, it's better used with a recursive table containing ID's and parent ID's, right ?


I'll play with it and try to write a tutorial this week-end.


Nice job Dmitry,


Cheers


Mathias


PS : did not find the autoexpand property but I only looked fast

I'm a very good housekeeper !
Each time I get a divorce, I keep the house

Zaza Gabor

Re: Final version 4.3

mathmathou wrote:

From what I see, it's better used with a recursive table containing ID's and parent ID's, right ?

Yes, support only this classic way with parent ID field.

Dmitry.

Re: Final version 4.3

Hello Mathmatou, Dmitry

Good idea to write a tutorial with this new component (TreeView).
Take a simple exampe : A discotek management (TreeView will display différents music styles : rock, blues, jazz ...) and a grid will display Performer, title and so on ...

For me , I'm testing this marvellous comonent.
I write again my MV application about butterflies and for which I was desperate to include a Treeview .
it will take time but it will be worth it.

In attachment, an illustration of what this will give.
I wait to see if we will proceed in the same way

Regards

JB

Post's attachments

Attachment icon Example.jpg 30.8 kb, 261 downloads since 2018-02-26 

Re: Final version 4.3

Dimitry,
Would you mind posting the new items in versions 4.0, 4.1 and 4.2. I remember seeing what's new in the forum for these versions, but apparently they have been removed. I like to keep track of new functionality in MVD for reference material. I appreciate it. Thank you.

Re: Final version 4.3

ehwagner wrote:

Dimitry,
Would you mind posting the new items in versions 4.0, 4.1 and 4.2. I remember seeing what's new in the forum for these versions, but apparently they have been removed. I like to keep track of new functionality in MVD for reference material. I appreciate it. Thank you.

Version 4.2
- Add markers to the map using the form, with additional data
- Added classes  TWebGMapsGeocoding and TWebGMapsReverseGeocoding
- Adding variables to a report using a script.
- Added function ShowRecordEx to populate form from another MySQL connection
- Added function GetEnvironmentVariable
- Added method GetElementById for class TWebBrowser
- Bug fixes


Version 4.1
- Added support scale for forms
- Added a property "Scaled" for form
- Added a property "MarkersDraggable" for a map component
- Values of components now available in a report
- Added functions Ping and PingEx
- Other minor modifications
- Some bug fixes


Version 4.0
- Google Map on the form with ability to set markers
- Added property "Searchable" for ComboBox, now you can find the required item directly in the component
- Added menu: File > Reopen, to open recent projects
- Slide grid view for TableGrid
- Added function Translate
- Added function GetAdaptersInfo
- Added functions EncryptFileRC5 and DecryptFileRC5 for encryption and descryption files
- Added some new properties and methods for components.
- Some bug fixes

Dmitry.

Re: Final version 4.3

Thank you Dimitry. Would it be asking too much to include your examples that you provided in the forum. It would help in understanding the syntax of the new functionality. Appreciate it.

Re: Final version 4.3

Here you can find examples:

ver 4.0
http://myvisualdatabase.com/forum/viewtopic.php?id=3845


ver 4.1
Added functions Ping and PingEx
example:

procedure Form1_Button6_OnClick (Sender: TObject; var Cancel: boolean);
begin
    if Ping('google.com') then ShowMessage('Ok') else ShowMessage('Failed');
end;

procedure Form1_Button4_OnClick (Sender: TObject; var Cancel: boolean);
var
    AvgMs: Double;
begin
    // avg time
    if PingEx('google.com', 5, AvgMs) then
        ShowMessage('Average ping: '+FloatToStr(AvgMs)+'ms')
     else ShowMessage('Failed');
end;

ver 4.2
http://myvisualdatabase.com/forum/viewtopic.php?id=4040

Dmitry.

Re: Final version 4.3

Excellent. Thank you Dimitry.

Re: Final version 4.3

Added function ShowRecordEx to populate form from another MySQL connection, that is great, any example on how to use it? Would it be possible to do the opposite (feeding another MySQL db)?

Re: Final version 4.3

tcoton wrote:

Added function ShowRecordEx to populate form from another MySQL connection, that is great, any example on how to use it? Would it be possible to do the opposite (feeding another MySQL db)?

Here you can find an example
http://myvisualdatabase.com/forum/viewtopic.php?id=4040

Dmitry.

Re: Final version 4.3

Dimitry,
I don't know if I hit on a bug or not for searchable combobox. Take a look at the attached sample. Click on the combobox and type a 1 into the field to filter the list without clicking on the down arrow of the combobox first. When you do this, the mouse cursor disappears.  If you click on the arrow to dropdown the list first and then start typing in the filter, the mouse cursor stays intact as it should. Can you look into why the mouse cursor disappears? Thank you.

Post's attachments

Attachment icon Searchable ComboBox.zip 579.98 kb, 475 downloads since 2018-03-06 

Re: Final version 4.3

ehwagner
Thank you for the project.
I know about this bug, it's look like the usual behavior for the component, I have test it in Delphi, same result. Unfortunately can't change it.

Dmitry.

Re: Final version 4.3

- New dialog for TreeView settings, now you can select multiple fields.
http://myvisualdatabase.com/forum/misc.php?action=pun_attachment&item=4123&download=0


- New property "Form", so you can add/edit records in the TreeView using form.



-

Post's attachments

Attachment icon TreeView.png 45.66 kb, 268 downloads since 2018-03-14 

Dmitry.

Re: Final version 4.3

Hello Dmitry

Good new
I've just download last MV version
How to open TreeView settings dialog ?

Thanks

JB

Re: Final version 4.3

Hello.


Same way like in the TableGrid.

Dmitry.

Re: Final version 4.3

Hello Dmitry

That was the subject of my question because I do not see the Settings property
as for a normal TableGrid (see attachment)

At when I hover over the Treeview icon on the toolbar, no hint appears as for other icons.

Regards

JB

Post's attachments

Attachment icon TreeView.jpg 67.99 kb, 241 downloads since 2018-03-15 

Re: Final version 4.3

Hello.


I have checked the archive, it's ok.
Please try to download again.

Dmitry.

Re: Final version 4.3

Hello Dmitry

Made a new download for 4.3 beta.
All is ok now, I see property Settings.

Would you have a small example to show the use of ParentId
(with 2 tables only) ?

Thanks by advance

Best regards
JB

Re: Final version 4.3

Hello.


What do you mean 2 tables?
In the folder Examples you can find a new example for TreeView

Dmitry.

Re: Final version 4.3

you are missing something you forgot:

when you over the mouse on the top menu tools, Save image on database, calendar, tablegrid , you don't have the "hint text" over the new tablegrid tree and google maps thingie.

Re: Final version 4.3

VascoMorais wrote:

you are missing something you forgot:

when you over the mouse on the top menu tools, Save image on database, calendar, tablegrid , you don't have the "hint text" over the new tablegrid tree and google maps thingie.

Thank you!

Dmitry.

23 (edited by sparrow 2018-06-02 20:31:51)

Re: Final version 4.3

DriveSoft wrote:

ehwagner
Thank you for the project.
I know about this bug, it's look like the usual behavior for the component, I have test it in Delphi, same result. Unfortunately can't change it.

Dimitry,
About this bug with combobox and mouse. This is a litlle modified project ehwagner. May be this help you about this bug. Add button search and table don't visible in project. Mouse cursor don't disappears and search works.

Post's attachments

Attachment icon Searchable ComboBox_ed.rar 293.72 kb, 465 downloads since 2018-06-02 

Re: Final version 4.3

Nice Workaround. Thank you.