Search options (Page 4 of 101)

Hi,
The problem is that 'Persona' does things (and appears very good) in a way that obviously play to its strengths and so MVD (and any other piece of software) will almost inevitably not compare as favourably. 
It also means that you run the risk of ignoring the strengths of MVD by only trying to mirror the way that 'Persona' works and not considering different approaches where MVD might be more suited.
So having said that, in principle, much of what you are asking about can be done in MVD using 'treeviews'.
However, my personal opinion is that 'treeview' functionality has some limitations (you can't easily drag and drop nodes, you can't by default re-sort nodes etc/  It can be done but just not 'out of the box' and you would need to write script.
My advice would be to mock up a small scale project in MVD using 'treeviews' and see exactly where you think it might come up short.  Then post back to the Forum (attaching your project) and contributors might be able to suggest not only how to overcome any 'treeview' specific problems you may have encountered but also suggest wholly different approaches (linked tablegrids comes immediately to mind) that might be more suitable to MVD.
Regards,
Derek.

Hi Kneeme,
It's more usual to use datetimepicker fields to add up times and then display the result in days, hour, minutes (and seconds, if required).
However, if you must use edit fields, I would use discrete edit fields for hours, minutes and seconds as per the attached example.
Obviously you could use just one edit field to hold hours, minutes and seconds but this makes things more complicated when you come to substring the edit field into its hours, minutes and seconds components.  Specifically
- how do you want the user to input the values - free-hand or with edit masks?
- do you force 2 digits for minutes and seconds?
- what is the maximum digits that the hours can go up to?
etc etc
Derek.

Hi Roberto,
If you want to increase / decrease the font size for all the edit, combobox and memo objects on a form, you could also do it something like this (see attached) which should save a bit of typing!
The attached example  uses ALT + A and ALT +D to increase / decrease the font
I sometimes find it useful to change font size, change object colour etc on forms that have a lot of input fields to make it easier for the user to see where they are (but obviously that is more interactive (ie when you actually enter / leave the input fields))
Regards,
Derek.

Salut Jean,
Ça va ?
As usual, it's good that MVD gives us options:
1 - 'namecase' capitalises every single word in the whole edit field.
2 - 'uppercase(form1.edit1.tex[1]) capitalises just the first word in the whole edit field.
It's all depends on what Vickus needs his application to do.
Bonne année,
Derek.

Hi,
The easiest way is probably to use the 'namecase' command (see attached).
The only slight disadvantage to this is that it doesn't work interactively (in other words, as you type).
Derek.

Hi,
Is there a particular reason why you are using a textbox instead of a datetimepicker to hold the time?
Derek.

Thank you Destiny and season's greetings to you too.
I wish you much success with your various MVD projects in 2024.
Regards,
Derek.

Hi,
Perhaps try it something like this (see attached).
In the example, I've added a new field ('roletohide') to the _user table to hold the role that needs to be hidden rather than hard coding it in the script.
It's a bit 'basic' (I'm busy with grandchildren and Christmas for my sins  and haven't much free time at the moment) but hopefully it gives you some ideas.
The passwords for all users is 'password' apart from Admin which is 'admin'.
Regards,
Derek.

Hi FMR,
It's not strictly the correct way to do it ( ) but if you just want something that is quick and easy then have a look at the attachment.
Just add an empty field to your lead table and add the user name immediately prior to running your report.  Then when you close the report, remove the user name.
Valid sigin-in details are admin / admin, FMR / password, Derek / password;
Derek.

Hi,

if form1.tablegrid1.cell[0,vi].asboolean = true  (asboolean) and also the form1.tablegrid1.cell[1,vi].asstring (asstring).

Basically, when you query the contents of an individual cell in a tablegrid, you need to specify 3 things
1.  which column the cell is located in (in your example, this is column 0)
2.  which row the cell is located in (in your example, this is the variable 'vi').
3.  what data type the cell contents contains (boolean, integer, datetime etc etc).  All cells are presented as strings in the tablegrid so, because a checkbox is a 'boolean' field, you need to specify '.asboolean' in your script if you want to perform some action on it.
Have a look at the amended example;  tick a couple of the checkboxes in the tablegrid and then click the 'all the checked' button and you can see the different data types being displayed in the 'message box' as you move through the tablegrid.
There are (as always with MVD) other ways of copying cells from the tablegrid to an edit or memo field that don't involve using the 'checkbox' - it all depends on what you are doing and how you want your application to flow.
I hope this makes things clearer.
Derek.

Hi,
Have a look at the attached example which loads data from an external .csv, shows what rows have been matched and which have not been found and then updates those rows that match.
Maybe this can give you some ideas.
Derek.

Hi,
I didn't realise that the part number could appear multiple times in your input file.
But it's a easy fix - just change the script to 'select sum(adjustment)' from .... etc etc.
Please see the amended attachment.
Derek.