Hi
You have the option to define the range status as rangestatus::Locked. queryBuildRange.value(<some value>) queryBuildRange.status(RangeStatus::Locked) regards /Bruno From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of V G Sent: 1. august 2007 22:34 To: [EMAIL PROTECTED]; [email protected] Subject: [development-axapta] add range.value in a query Hi I want to add a range in a query where the value of the field must not be empty. like in this example we added a range where salesstatus cannot be canceled or invoiced. newQueryRun.query().dataSourceNo(1).addRange(fieldNum(salesTable, salesStatus)).value('!Canceled, !Invoiced'); similarly is there a way tto define a range so that the only records which have some value in there project field are selected. Thanks in advance VG [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
