Tuesday, January 17, 2012

How to disable a query range from user

Sometimes we do not want the user to change the query range on a form or a  report.
To hide this from user, we need to write the following code for the range of the query.
In my case I have written a queryrange on the init() method of the datasource in a form.


    queryRange = this.query().dataSourceTable(TableNum(CustTable))
                          .addRange(fieldnum(CustTable,CustStatus));
    queryRange .value('close');
    //to make the field uneditable use the following code
    queryRange .status(1);



 Reference: http://support.microsoft.com/kb/910958