Evaluate returning Nothing

HCL Domino Domino Forum
1

Dear All

I have a problem with this line as it is returning nothing.

i hav to check the user who logged in is in a multivalued field

“InitiatorBackup” or not

'IBperson =Evaluate(“@ismember(CloSession.UserName;InitiatorBackup)”,CloDoc)

I tried this one also but no result

'IBperson =Evaluate({@ismember(CloSession.UserName;InitiatorBackup)},CloDoc)

both the cases evaluates returns 0 even though the user is in the field InitiatorBackup

i got this by the following code

Dim itm As NotesItem

Set itm=CloDoc.GetFirstItem(“InitiatorBackup”)

For d=0 To Ubound(itm.Values)

If CloSession.UserName=itm.Values(d) Then

IBperson=True

Exit For

End If

Next

thanks in advance

anil

2

Subject: Evaluate returning Nothing

Evaluate does not like dynamic values I normally use it as follows

Const EvalFormula$ = “<notesformula|field>”

doc.tmpfield =

tmpvar = Evaluate(evalformula, doc)

3

Subject: RE: Evaluate returning Nothing

Hi yazdithanks for ur response but it always returning 1 ie even though the user logged-in is not there in the field"initiatorsbackup"

regards

anil

4

Subject: Evaluate returning Nothing>>Mistake iss

Dear AllI found the Found mistake

Error Code>>

Evaluate(“@ismember(CloSession.UserName;InitiatorBackup)”,CloDoc)

corrrect Code is

Evaluate(“@ismember(@UserName;InitiatorBackup)”,CloDoc)

Earlier i wrote script in @function

Thanks for ur responses

5

Subject: Evaluate returning Nothing

From what I see, you are mixing Lotus script and Formula, you need to separate the two. Keep the formula between the brackets ({}) and add the Lotus script with +.

IBperson =Evaluate({@ismember(} + CloSession.UserName + {;InitiatorBackup)},CloDoc)

6

Subject: RE: Evaluate returning Nothing

Hi Alain

thanks for your fast reply, but am sorry it is throughing error

“operation failed”