Search options (Page 90 of 104)

Hi Manixs,
Attached is the perhaps the simplest way of doing what you want;  there are other ways that can automate things more but they require more script.
Please note that the script in the attachment is not essential for what you want to do - it just makes the 'save' button visible / invisible;  this is to prevent accidentally duplicating records (which can be a problem when doing everything on the same form).
Hope this helps,
Derek.

Hello Kim,
If I understand correctly and your condition is only valid for a new record, then you could try the following test in your script:
procedure xxxxxxxx
begin
   if action = 'NewRecord' then
      begin..........
         etc etc
     end;
end;
However, the test for 'newrecord' is usually associated with the formxxxx on_show procedure so if you are using the same form for new records and for editing records, you might need to amend this.
Derek.

Hi Kim,
The sql error is to do with Form3 - you have a mixture of fields from tabone, tabtwo and tabthree on this form but your 'save' button is defined to save them all to tabthree.
It would be far easier just to use different forms - one form to maintain tabone fields, one form to maintain tabtwo fields and one form to maintain tabthree fields.
Derek.

Hi Nitin, Hi Kim,
If you didn't want to use a script, you could also try using a calculated field (see attached).  I've chosen to display to 3 decimal places but you can change the format to whatever you want in the calculated field.
Regards,
Derek.

Hi Kim, Hi EHW,
You beat me to it, EHW - I was about to say the same thing about defining fields as 'real'.
With regard to your other issue, I see what you are trying to do but I think you'll have to:
1)  define the lower and upper values of each range (both old and new) as discrete fields - trying to determine which item falls within which range when the lower and upper range is defined in 1 text field will be very tricky.
2)  perhaps use calculated fields to determine which old range and which new range an item falls into, what the old calculated value is, what the new calculated value is and the difference between the two.  This could then be displayed in a tablegrid with totals.
(By the way, I'm presuming that your ranges do not overlap otherwise the calculation would not work).
Derek.

Hi Nitin,
Perhaps you can use calculated fields to replace 'Yes' or 'No' with the day of the week.
Please see attachment (I have only done it for 'Monday' and 'Tuesday' to show how it might be done).
Maybe this helps?
Derek.

Hi Dmitry,
Thanks for doing this. I am on vacation at the moment, but will test it when I am back home and let you know how I get on.
Regards,
Derek

Hi Adam,
Probably a couple of ways to do this but I'd suggest using calculated fields on the saleinv table and then displaying the total sales and total refunds values on form1.tgmaincustomerstrans (I've also added an invoice line count just to add a bit of extra info). 
This way, you see not only the total of the sales and refund values for each invoice (but without having to click on it), and you also get a grand total of sales and refund values for ALL invoices for that particular customer (see attached).  Just a thought.
Regards,
Derek.

Hi Mathias,
Hope things are good in your corner of the world.
Thank for having a look.  I've not had any problems on any one's PC when using 'openurl' but wanted to get it working with twebbrowser because it just looks integrated.
The map.show line is in the script to show Dmitry the steps I'd taken but if this problem can't be fixed, I can take most of that section out.
I believe there is a registry 'tweak' but I don't know every machine where my app is being used so that's not a solution for me.
Maybe Dmitry can think of something.
Regards,
Derek.

Hi Kim,
Not sure if I understand your exact problems, but I'll have a go.
One of the issues in your app seemed to be that the two grids weren't 'talking' to each other - have a look at the attachment as a possible way to do this (it uses a 'search' function to take a specific row in tablegrid1 as a criteria to display related records in tablegrid2).  Apologies if it sounds more complicated than it actually is - once you've done a couple, it becomes very straightforward.
Another issue seemed to be some sort of calculation between the cereal weight and the summed weight of sub-entries so have a look at using a calculated field in the table structure (see attachment) to warn of this (but it's just one of many ways you could do it).
As an observation, in your app, you are using the same form to add / edit records.  It's okay to do it that way but can cause problems with duplicate records (try saving a record in your app and then press 'enter' a few times to watch the duplicates increase!).  In my opinion (for what it's worth LOL!), using a discrete form to add/edit records is a much safer option, particularly if you are new to MVD.
Hope this takes you forward a bit and please come back to the Forum if there's anything that's not clear.
Derek.

Hi Kim,
Not quite sure where the problem is with deleting a record;  bear in mind that if you use the auto-increment feature, when you delete a record, that particular number does not get reallocated (ie if you have records 1,2,3,4 and 5 and you delete record 2, the next auto-incremented no' is 6;  record 2 does not get re-used).
Have a look at the attached example and see if it is doing what you expect.
Regards,
Derek.

Hi Kim,
If I understand your question correctly, then it's not really how MVD works.
Forms are opened more in a hierarchy so when you want to 'switch', subordinate forms need to be closed first. 
For me, that's the main reason to use 'page control'.  Each tabsheet becomes, in effect, a form (but with no hierarchy) which enables you to switch between tabsheets/'forms' without restriction.
If you don't want all of the tabsheets to be displayed all the time, you can set the 'tabvisible' property of any of the tabsheets to 'false' or 'true' depending on which tabsheets you want to see.
How  you best do that depends on why you only want certain tabsheets showing rather than all of them, so if you can give a bit more background to your project, then people might be able to come up with further ideas.
Derek.