Hi all,
a strange effect/bug:
An scheduled LS agent change a view column formula like:
Forall vc In view.Columns
If vc.IsFormula Then
vcformula = Trim(vc.Formula)
If Instr(1,vcformula,CTodayFormula,1) > 0 Then
vc.Formula = mynewcolumnformula
End If
End If
End Forall
After that change the form formula of that view is empty!!
ugly …
Uwe
Subject: read Help
Note what it says about view.Columns…Usage
To set the value of an individual NotesViewColumn object, you need to access the array elements individually. For example, to get the first element in the array returned from the NotesView object view, you could do the following:
Dim column as NotesViewColumn
Set column = view.Columns( 0 )
Subject: maybe you misunderstood my posting
Hi Watka,
sorry when I posted it not clearly enough:
I am successfully changing view column formulas,
BUT:
when doing this, the FORM formula of that view gets lost!
the columns are ok.
Uwe
Subject: try it the way Help tells you
Form is not a property of NotesView. Maybe doing it the “Help” way will fix it, something like this…
Dim i as Integer
For i = 0 to view.ColumnCount
Set column = view.Columns( i )
… do your logic
Next i
Subject: still misunderstood
thanks for your answer Watka Naidoo,
but you still misunderstood my q.
the column formulas are OK, the view FORM FORMULA get lost!! (I do nothing with that, there isn’t even a method/property for view form formula in LS)
Please look at my other thread:
Andre told me that it is a known bug, fixed in 8.5
but thx for your answers anyway 
Uwe