评估语句宏中的错误 [英] Error in Evaluate statement macro

问题描述

我对evaluate statement有问题.我想在一个类中使用此函数，因为我想在Lotusscript中使用公式@DbLookup.

I have a problem with an evaluate statement. I am trying to use this function into in a class, because I want to use the formula @DbLookup into lotusscript.

这是我的课程代码:

Class DirectorSucursal

    Private m_branch As String

    'Constructor class
    Public Sub New (branch)
        me.m_branch = branch
    End Sub

    'Deleter Class
    Public Sub Delete

    End Sub

    'Function show the field value
    Public sub GetBranch
        MsgBox m_branch
    End Sub

    'Function get the name director
    Public Function getNameDirector

        getNameDirector = Evaluate ({@DbLookup("":"NoCache";"C1256EAD:00478951";"People2"; "D" + m_branch; "FullName"})

    End Function

End Class

我在getNameDirector = ...

评估宏错误

Error in evaluate macro

我在做什么错了?

谢谢

推荐答案

您的代码应为

getNameDirector = Evaluate({@DbLookup("":"NoCache";"C1256EAD:00478951";"People2"; "D} + m_branch + {"; "FullName")})

您必须将变量m_branch放在{...}字符串之外，并且您错过了@DbLookup的结尾)".

You have to put variable m_branch outside the {...} strings and you missed @DbLookup's closing ")".

这篇关于评估语句宏中的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！