Topic: Version 3.1 final

I'm glad to announce a new version of My Visual Database 3.1 final


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



What's new?
- Editable TableGrid.


It will reduce the number of forms in your project.


How to activate:
http://myvisualdatabase.com/forum/misc.php?action=pun_attachment&item=2577&download=0


- Added class TComPort, example: http://myvisualdatabase.com/forum/viewtopic.php?id=2951


- Fixed several memory leaks.


- Added function ShowRecord, allows open form filled specific record.


- Added class TRegExp (regular expression), example: http://myvisualdatabase.com/forum/viewtopic.php?id=2953



The update is free if you have purchased a license in August or later.



-

Post's attachments

Attachment icon editable.png 13.7 kb, 463 downloads since 2016-11-17 

Dmitry.

Re: Version 3.1 final

Sounds good, do you have any example of editable tablegrid to see what we could do with it?

Re: Version 3.1 final

Hello Dmitry

Good news with MVD 3.0
As TCoton, I would be happy to see how these 4 new properties work.
I created a table with 3 fields (2 Text and 1 Date).
I tried to create new record by putting these 4 properties to True.
Nothing happens.

JB

Re: Version 3.1 final

tcoton wrote:

Sounds good, do you have any example of editable tablegrid to see what we could do with it?

Just enable these new properties and if your TableGrid have data, you can create and edit data directly in the TableGrid.

Dmitry.

Re: Version 3.1 final

jean.brezhonek wrote:

Hello Dmitry

Good news with MVD 3.0
As TCoton, I would be happy to see how these 4 new properties work.
I created a table with 3 fields (2 Text and 1 Date).
I tried to create new record by putting these 4 properties to True.
Nothing happens.

JB

Hello.


It should works, please attach your project.

Dmitry.

Re: Version 3.1 final

i have version 2.8 with minor update license.  do i need to buy new license to use version 3?

Re: Version 3.1 final

doing.whatever.it.takes wrote:

i have version 2.8 with minor update license.  do i need to buy new license to use version 3?

If you have purchased a license in August 2016 or later, you will get all updates 3.xx for free.


But version 3.0 alpha can use all registered users (2.xx).

Dmitry.

Re: Version 3.1 final

Good Evening Dmitry,
Thanks for the latest version of MVD - it looks excellent.
The in-grid editing feature is a MAJOR improvement and will change the way many of us create our projects - much faster, much simpler.  I already want to re-write some of my projects (oh no!!).
I am just doing some basic testing to find out more about it and I have two questions
1.  It is possible to create a record 'in-grid' and it is possible to edit a record 'in-grid'.  But is it possible to delete a record 'in-grid?
2.  If I use the keyboard (TAB or ARROW keys) to create or edit records 'in-grid', any combobox that is associated with a column does not display its 'icon' (to open combobox);  I have to switch to using the mouse for this to be displayed.  Is there a keyboard shortcut / keyboard combination that will do this n MVD?  (please see attached screenshot).  In other software, it is often the 'ALT+DOWN ARROW' or F4 but I have tried all the obvious combinations.
Thanks again,
Derek.

Post's attachments

Attachment icon test MVD 3.0 alpha.zip 399.84 kb, 612 downloads since 2016-11-17 

Re: Version 3.1 final

derek
Hello.


1. I will do it before final version.


2. In the current alpha version it's not possible but I will try to do it.

Dmitry.

Re: Version 3.1 final

hi
in the alpha version 3.01
1 the colors af the lines of the grid that i created by script are wrong
2 whene i creat an exel table. colombs are all numbers (foreng keys)
thank you

Re: Version 3.1 final

hichame wrote:

hi
in the alpha version 3.01
1 the colors af the lines of the grid that i created by script are wrong
2 whene i creat an exel table. colombs are all numbers (foreng keys)
thank you

Hello.


1. Please attach your project with description, where colors are wrong.


2. Unfortunately I can't understand the question.

Dmitry.

Re: Version 3.1 final

Hi Dmitry,


Is there planned public release date of first MVD 3x?

Adam
God... please help me become the person my dog thinks I am.

Re: Version 3.1 final

AD1408 wrote:

Hi Dmitry,


Is there planned public release date of first MVD 3x?

Hello.


In 1-2 weeks.

Dmitry.

14 (edited by krokodil_sk 2016-11-30 15:01:41)

Re: Version 3.1 final

Dear Dimitry,
I found one bug.
After use MVD 3.02 alpha.
MVD returned error please view attachment.
This error show after click on button.
When i use MVD 2.8 no error show and anything work OK.
I use MYSQL.
If you want i can send my project.
This ComMatrixOsoby.commatrixosoby_emergency have type BOOLEAN not INTEGER what you see in error.
Recreating the database not help.

Bgrds,

Krokodil

Post's attachments

Attachment icon error.JPG 15.1 kb, 341 downloads since 2016-11-30 

Re: Version 3.1 final

krokodil_sk
Thank you for the bug report, please send me your project to support@drive-software.com
Also describe steps to introduce the error.

Dmitry.

Re: Version 3.1 final

Dmitry,

project already sent.

Brgds,

Krokodil

Re: Version 3.1 final

krokodil_sk wrote:

Dmitry,

project already sent.

Brgds,

Krokodil

Unfortunately not received.
Can you send me again?

Dmitry.

Re: Version 3.1 final

Done

Re: Version 3.1 final

krokodil_sk wrote:

Done

Thanks.

Dmitry.

20 (edited by timlitw 2016-12-13 20:14:01)

Re: Version 3.1 final

Thanks for the wonderful program!
Also thanks for the 50% off upgrade!

Re: Version 3.1 final

Same thing here, great great great.


Thanks Dmitry smile

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

Zaza Gabor

Re: Version 3.1 final

Hi Dmitry,


Thank you for the MVD 3.1...


Is there sample projects showing editable tGrid in action?
I have tried simple 1 table 3 fields project but got errors.


It'd be very helpful if you could make couple of sample project utilizing on editable tGrid:
1. Simple project without a script
2. Not so simple project, most likely with script showing usage of comboboxes, boolean, images, url and other links etc (whatever editable tGrid can support) in tGrid cells.

Adam
God... please help me become the person my dog thinks I am.

Re: Version 3.1 final

AD1408
To enable this feature you should just enable the properties
http://myvisualdatabase.com/forum/misc.php?action=pun_attachment&item=2577&download=0


No additional action requirement.


Can you attach your project in which you get an error, perhaps you found some bug.

Dmitry.

24 (edited by AD1408 2016-12-15 06:24:45)

Re: Version 3.1 final

Dmitry,


Error occurs during tGrid cells data add/edit then save (Clicking on next row once finished adding values) when #(Auto Increment) used on tGrid settings.


Followings are my shortcomings, I don't think they are related to app bug. That was the reason I asked for example projects. Anyhow, I have created one with errors that I cannot resolve.


1. When adding/Editing data to a tGrid via another form and tGrid I get multiple records displayed on secondary table. (Form1 Invoices and Customers / Forms Inv and Customer)


2. I couldn't get linked all (comboboxes) work. Please see Inv form


3. I have no idea how to calculate on Inv form the followings:
net price= (qty * unit price)
tax amount = (net price * tax rate / 100)
item total= (net price +Tax amount)
I like to put calculation scripts on script page not within fields on db tables as calc fields.


4. Db Image field didn't work in tGrid cell. Perhaps it's not supported yet.


5. It'd be nice to have Add / Edit buttons for tGrid on same form as it wont't be clear for many users clicking on tGrid cells at first. Clicking on Add would put cursor on first available cell. Clicking on edit button would place cursor on on first editable cell of selected record on tGrid.

Post's attachments

Attachment icon testMVD31tGrid.zip 8.65 kb, 568 downloads since 2016-12-15 

Adam
God... please help me become the person my dog thinks I am.

Re: Version 3.1 final

AD1408
1-2.
On form "inv" in the component "tgInv" you have a field "TaxRate.tax_rate", you can show it, but you can't change it, because this field belongs to another table. When you create/edit record directly in a TableGrid, you can't create/edit record in two table at same time.


Also I bit do not understand the structure of your forms. On form "inv" no need the component "tgInv".


3. http://myvisualdatabase.com/forum/viewtopic.php?id=1416



4. it's not supported yet.


5. it's not supported yet. But it's nice idea. Thanks.


p.s.
Here you can find project with invoices
http://myvisualdatabase.com/database_ex … oices.html

Dmitry.