Hi Kristanto, Perfect!
Thanks, Suki ________________________________ From: kristanto surjadi <kristantosurj...@yahoo.com> To: development-axapta@yahoogroups.com Sent: Friday, 17 September, 2010 7:14:25 Subject: Re: [development-axapta] Locking field in SysQueryForm Hi Suki, You can use status method in QueryBuildRange. Example: QueryBuildRange qr; qr = salesTable_ds.query().dataSourceTable(tablenum(salesTable)).addRange(fieldnum(salesTable,InvoiceAccount)); qr.status(rangeStatus::Locked); With this code even if they open SysQueryForm you criteria will be locked and not available for changes. Cheers, --- On Wed, 9/15/10, suki.sherg...@btopenworld.com <suki.sherg...@btopenworld.com> wrote: From: suki.sherg...@btopenworld.com <suki.sherg...@btopenworld.com> Subject: [development-axapta] Locking field in SysQueryForm To: development-axapta@yahoogroups.com Received: Wednesday, September 15, 2010, 3:02 PM Hi All, I've added a new field to the Table/SalesTable. I've modified the Form/SalesTable query to restrict the records shown on the grid for certain users using my new field. This all works OK. My problem is that the user is able to invoke the SysQueryForm and change the query and change the restriction I've added to the query and see the records they shouldn't. How do I disable the editing of my new field in the SysQueryForm? Thanks, Suki [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
