Is there a way of protecting a specific column in a DW by referencing by row, e.g. I want to input to column A in 1st row, but disable A in 2nd, Modify does not allow row to be used, so end up disabling all rows.
Does not seem to work in Datawindow by setting expression in General tab / Protect, or in PB script?
Hi.
You can add an expression to "protect" property in your datawindow for the columns you want to be affected.
How this should be done it depends from what you want to achieve.
If you want to protect a specific column for the second line, the expression to use should be:
if(getrow()=2,1,0)The expression should be set to all the columns that you want to be affected.
Also you can add code to the rowfocuschanged event to change the protect property when some situation occurs.
Using describe: .Describe(".Protect")
Using dot notation: .Object.Protect
Example:
if currentrow = 2 then
Object.myColumn.Protect = '1'
else
Object.myColumn.Protect = '0'
end ifFinally, there is a way to modify an expression in runtime, but this is more complex...
Ex (modified from help):
dw1.Modify("emp_stat.Protect='1~tIf(getrow()=2,1,0)'")or
dw1.object.emp_stat.Protect='1~tIf(getrow()=,1,0)'Andreas.
