Thursday, 10 March 2011

@dblookup in LotusScript

Here is the code...

Function DBLookup (strClass As String, strNoCache As String, strServer As String, strDatabase As String, strView As String, strKey As String, strReturn As String) As Variant Dim strFormula As String,quotes As String quotes = Chr(34) strFormula = “@DbLookup(& quotes & strClass & quotes &:& quotes & strNoCache & quotes & “;” & quotes & strServer & quotes &:& quotes & strDatabase & quotes & “;” & quotes & strView & quotes & “;” & quotes & strKey & quotes & “;” & strReturn &)” DbLookup = Evaluate( strFormula ) End Function

No comments:

Post a Comment