Search options (Page 96 of 104)

Hello Adam,
If you have defined your fields as 'not null', then standard MVD will check that something has been entered into those fields - but 0 is allowed (and may well be valid).
However, what you could do in Form1 of your example, is to untick the 'currency' object property for your two currency fields (see attached screen shot) so that when you run the application, all 4 fields (2 currency, 1 real and 1 integer) display as blank;  at least then the User has to make the conscious decision to enter a value of 0 (rather than it defaulting  to 0 as it does when the 'currency' property is left ticked).  It is perhaps a bit less rigorous than the error checking that Mathias suggested to you but it can be done quickly and with no scripting.
To my knowledge, the message "This field is required......" that you get when a field has been left blank, is a standard message that cannot be amended.  It is 'switched on' when you configure the 'save' button on your forms.
Derek.

Hello Adam, Hello Mathias,
I was just having a look at your project and there are a couple of points (and if you know this already, just ignore me - ha ha!).
You need to understand that calculated fields are not actual fields that are stored in tables - have a look at screenshot 1.jpg in the attachment .  Calculated fields are just empty containers that temporarily store the result of calculations based on actual fields in the table.  This is why, in your very first attempt, the calculation was not being done - you have no 'save' button so no actual fields are being written to the table and therefore, if you don't have any actual fields written to the table, there is no data to perform the calculation on.
If you understand this, you see that with Mathias' solution (which works perfectly) you don't need a table defined at all.  It uses the edit fields from Form1 to input values, then performs calculations solely within the script and then outputs the result back to Form1.
Maybe you'll find the attachment of interest - it takes another approach and actually saves your input fields to the table and, because it then has some actual data to use, can perform the formulae defined in your calculated fields and can then display the result back to you.
It doesn't matter which approach you use but maybe seeing the two helps you to better understand the advantages and disadvantages of calculated fields against doing calculations in a script.
Derek.

Hello AD1408,
I don't believe it is a version issue (I am using 2.5 but went all the way back to 2.1 just to be on the safe side and it still works okay for me).
The copy and paste you've done is fine so the only thing I can think of is that the directory and/or file name that you entered (zztemp\test.txt) does not exist at your end, in which case when you click it will simply do nothing.
Derek.

Hi AD1408,
If you hide the Windows menu bar using a script, you need to reduce the depth of your form by a corresponding amount (even if it appears to be reducing the height of your panel;  when you execute it, it should then look okay).  Alternatively, you can change the form's object properties (Additional / BorderIcons / Borderstyle = BSDialogue).
I think your weblink should be attached to a 'double-click' event rather than a 'single-click' event.  Alternatively, attach the URL instruction directly to the button.
See attached.
Derek

Hi AD1408,
1.  Attached is your project to which I have added a lookups table and form.  Now on the lookups for customer title, customer group, customer status, customer bleeper etc, you should see how this is working all off only one table.  Please note that I have not changed any of your existing table structure as there is too much in there and I would just be introducing errors in making such large changes.  Maybe now you can see how it works and how it can be quicker and easier to create (for your project, 1 table instead of 26 and just 1 form instead of 26 (or using many page controls).
2.  In order to give you an idea of menus, one simple way was to change the 'style' of the page controls that you use from 'tab' to 'menu' (it is an object property of the page control).  I have then added some extra buttons to call other forms;  so you have a mixture of page control and button but it all looks the same.  But there are quite a few ways of setting out menus - it really is which works best for your project.
3.  I have added what I think is the easiest way to create a help file.  Click on the User Guide/Help button and you will see that it is simply one very big label in which you can add all the help information that you need).  Again, there are lots of different ways, but this is, I think, very simple.
Derek.

Hello Again AD1408, Jean,

With regard to your question (1. How do I calculate totals of a table grid?), please find attached the script you need.
However, unless you have a specific reason for using edit fields for your grid totals,  it is probably more efficient and certainly easier just to use the grid totalling options that you get with standard MVD.  The attached screenshot shows you where to find them and how to do it.

If I have some time, I will try and re-work a bit of your project to show you the approach to lookups with just one table that I use.  I can also include the way I create a 'help file' and a simple 'menu structure' that I often use, if that would be of any interest to you.

Derek.

Hi AD1408,
A simple demo is attached for you.  For example, I want to create a project with information about people. 
It has 3 lookups (but obviously it can be many more) for 1.eye colour, 2. height and 3. zodiac sign.
Using my attached project, these are the stages you must follow;

screenshot1.jpg
1.  create a table ('people')
2.  create a table ('lookups') with 2 fields ('lookupkey' and 'lookupvalue').
3.  create 3 relationships from the 'lookups' table to the 'people' table (1 relationship for each lookup) .
4.  create 3 calculated fields to retrieve the 'lookupvalue' field (1 calculated field for each lookupvalue).

5.  create your forms (form3 and form4 are for the lookups - you will only ever need these 2 forms even if you add 100 more lookups!).

screenshot2.jpg
6.  set the foreignkey and fieldname properties of each combobox and add the filter property

screenshot3.jpg
7.  add data to your 'lookups' table

screenshot4.jpg
8.  when adding data to the 'people' table, your comboboxes should retrieve the correct lookupvalues.

Usually, this would require 4 tables and 6 forms;  this way, it requires only 2 tables and 4 forms.

I am not sure what you mean when you write "I have too many lookup items to put in one list....".  Remember than when you add the filter to the combobox property, you are, in effect, creating sub-lists that would contain the same number of rows as doing it the usual way.

Hope this helps,

Derek.

Hello Eric,
Any chance you can zip up your project (without the .exe file) and attach it? 
Then someone in the Forum will be able to look at it and point you in the right direction.   
There are a number of 'standard' things you need to do when creating even basic projects and it's easy to forget a couple of them when you are new to MVD (we've all done it, so you are in good company!).
Derek.

Hello Iacovlogica, Dmitry,
Thank you for your reply. 
However, my question to Dmitry is WHY can you call a form and use the 'sleep' function to display it for x seconds BUT any objects on that form are NOT shown. 
If
  logo.show;
  sleep(5000);
  logo.close;
is syntactically correct and the form is successfully opened, displayed for the correct time and then closed, I would expect any objects placed on that form to also be displayed, unless there is perhaps a bug.
Derek.

Hi,
One way to do it would be to save the 'copy / create' record and then select, one at a time, from a second tablegrid, the phone numbers you also want to 'copy / create'.   I've attached an example of how I might do it, but I imagine there are other ways too.
Another option might be to use the 'go multiselect' option on the tablegrid that contains the phone numbers.  I've used 'go multiselect' to delete multiple rows so I can't see any reason why it wouldn't work with inserts, although I've not tried it.
Derek.

Hello V_Pozidis,

I do something similar where a new record is created based on an existing record with only one or two small changes (a copy/create).  Basically,
1)  the user selects an existing row in the tablegrid that he wants to use as a basis for the copy/create
2)  clicks 'copy'
3)  the chosen row is displayed (read only) so the user can verify the correct row is being used as the basis for the copy/create
4)  any changes are made as required
5)  click 'save'  and the new row is created.
I have attached a simplified version of my project for you to see it working.  Maybe this will help you.
Derek.