Subject Re: Data module with a complex index
From Akshat Kapoor <>
Date Sat, 7 Dec 2019 17:53:13 +0530
Newsgroups dbase.getting-started

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.

    function PRINT_onClick()
       set procedure to p_tax.rep
       r = new p_taxreport()
       r.taxdatamodule1.tax2.params["invoice"].value = str(minvoice,10,0)
       if r.printer.chooseprinter()
          r.title = "Tax Invoice No. (Original)"+ minvoice
       close procedure p_tax.rep