Update multiple table data in the same form
Update multiple table data in the same form
(OP)
Well Im a clarion programer (beginner) so I need to update data from diferent tables using the same update procedure.
(In the same window can update costumer and detail for envoice)
Actually I can call the update procedure using a button, but i want in the same window.
If you can help, i really apreciate.
Jorge Garcia
(In the same window can update costumer and detail for envoice)
Actually I can call the update procedure using a button, but i want in the same window.
If you can help, i really apreciate.
Jorge Garcia
RE: Update multiple table data in the same form
IF NOT ReturnValue ! if primary file update was sucessful
Relate:SECFILE1.Update()
Relate:SECFILE2.Update()
...
END
If the the procedure is a basic WINDOW procedure, you could place the code in the EMBED of the OK button.
In your case the INVOICE would be the Primary File and CUSTOMER would be the secondary file.
RE: Update multiple table data in the same form
A cool way to do what you want is to declare a VIEW. Look in the help it shows how to do it.
Valery.
RE: Update multiple table data in the same form
RE: Update multiple table data in the same form
And it works great.