||Re: Data module with a complex index
Akshat Kapoor <firstname.lastname@example.org>
||Sat, 7 Dec 2019 17:53:13 +0530
On 07-12-2019 17:09, Robbie Nott wrote:
> Hi Akshat
> Thanks you very much for the information.
> I was hoping to have all the query and table code in one place.
> If I have to do stuff in the form to manipulate the
> data module then it kind of defeats the purpose...
> Your assistance is greatly appreciated
> Greetings from wet and rainy Johannesburg
Editing of Datamodules is hardly required.
In fact I open the datamodules in source editor only when I want to view
the query for some reason.
For Most uses setting the value of params in forms and then requey() is
And at times the same datamodule is used in multiple places (Form and
Report generally use the same datamodule).
A typical print routine that I use to print invoices.
set procedure to p_tax.rep
r = new p_taxreport()
r.taxdatamodule1.tax2.params["invoice"].value = str(minvoice,10,0)
r.title = "Tax Invoice No. (Original)"+ minvoice
close procedure p_tax.rep