Receipts on sales mandate (Page 1 of 2)

Hi derek,
as always thank you very much. I'm trying to understand your project to be able to apply it to mine.
For the moment I immediately had a doubt: in your project I tried to create a button to print a report with the list of all the articles of a receipt but I didn't understand anything.

Bravo derek!
that's just what I wanted. Only now I have to study well because at the moment I haven't understood anything!

I'm reading. I Always forget it exists.

Hi,
There are a couple of things to understand when using calculated fields.
Calculated fields only exist while your program is running - as soon as the program closes, the calculated fields are gone.  For example, you would save someone's date of birth but you wouldn't save their age - that would be data redundancy.  Instead, you calculate their age every time the program runs using a calculated field so it is always up to date, but as soon as the program closes, their 'age' is gone.
So you are correct when you say that there are no instructions DIRECTLY relating to calculated fields in the script.  But what the script does is
1)  run a search when the program starts so that all the columns in the tablegrid are populated - including calculating the calculated fields.
2)  when any data is saved, the calculated fields need to be 're-calculated' - this is what the 'dbupdate' statements are doing in the script.
So when you removed the script, the calculated fields didn't appear because you removed the instruction to calculate / re-calculate them.
I hope I've explained that okay.
I've attached the project again with some comments in the script that may help.
Regards,
Derek.

Yes, you understand it correctly - calculated fields are temporary and only exist when the program is running.  Saved fields exist even when the program is closed.

Hi,
In your script, first declare your variable
var  variable1: string; 

and then
variable1 := form1.edit1.text;

Derek.

Hi,
I always try to keep things simple (LOL!) so in this example, I would use the percentage value that you enter in form1.edit4 directly - there is no need to create a separate variable.
procedure Form1_Edit4_OnChange (Sender: TObject);
begin
  Form1.Edit5.Value:=(Form1.Edit2.Value * Form1.Edit3.Value) - (form1.edit4.value / 100);
end;
Please see attached.
Derek.

Hi,
Yes, I would always use 'onchange' for something like this.
You might also think about putting an 'onchange' event against 'selling price' and 'quantity' as well because these are also used in your calculation and you could change these values but it wouldn't automatically recalculate until you changed (or re-entered) 'percentage gain'.
Rather than repeat the calculation on each 'onchange' event, I put it in my own procedure (because it's easier to maintain - if you change the calculation, you only have to change it in one place in the script).
Derek.

Sorry, but I can't quite work out what you're trying to do.
Can you attach your program?

Hi,
If Form1 is your main form (the first 'tab' on the left of your form tabs - see attached screenshot), then all the other forms are called from Form1.  So if you try to close Form1, all the other forms that are called by Form1 will close as well.
Make Form2 the first tab (drag it to the left) and then open Form1 by script.
Derek.

Thanks very much to you too ehwagner and as always to you derek.
derek, I tried to translate most of your teachings into my project, I still have to finish. Unfortunately I am faced with a problem that I cannot solve. This is the modification of my first project that you already know well and on which you have already given me a great hand.
In practice I tried to make a copy of the "frmContratto" form on the "frmRicevuta" form. To save time I have copied and pasted the controls in the new form (frmRicevuta) but I don't know if it is a correct procedure, then I made the necessary changes but something I did wrong.
If you remember in the "frmContratto" form, selecting the first gridtable a name in the second gridtable gave me the list of contracts related to the user, then it was enough to click on the contract and the press would start.
In the copy form (frmRicevuta) this function has disappeared or the association of documents to the user.
In addition, if I click twice on the user name, the user search works, nothing happens while the "frmListaricevute" form should open, the "Modify" button has the same behavior. In any case I would ask you to take a look at the project I am attaching, by launching the executable you need to choose "Ricevuta" to see the behavior I described.
I don't know how to ask you any more thanks!  Sooner or later I will learn.