DbLookup in Lotus Script

HCL Domino Domino Forum
1

Hi,

Can someone help me with the syntax? I’m trying to convert this code in Lotus Scrip, this is all from a Local Copy :

days := @DbLookup(“” : “NoCache”;@DbName; “vwKeywords”; “DaysLimit”; 2);

thank you very much in advance.

2

Subject: DbLookup in Lotus Script

I got this from another source in the forums:

REM { Easy way to code @DbLookup };

Code: CLASS := “Notes”;

NOCACHE := “NoCache”;

CACHE := “Cache”;

SERVER := “”;

DATABASE := “”;

VIEW := “vwKeywords”;

KEY := DaysLimit;

COLUMN := 2;

days := @DbLookup(CLASS : CACHE; SERVER : DATABASE; VIEW; KEY; COLUMN);

@If(@IsError(days); “”; days)

This has helped for me.

Bob

3

Subject: RE: DbLookup in Lotus Script

Yes looks good but I need it in Lotus Script.

Thanks

4

Subject: RE: DbLookup in Lotus Script

I have a keyword, which is a numeric number, and dates avec being compared to that numeric number which can change anytime if the Administrator changes it. So I need to extract the value of that number so I can compare it with field values.

5

Subject: RE: DbLookup in Lotus Script

You can use Evaluate to just execute the macro language from LotusScript. Pass it a NotesDocument as second argument.

Other than that – you have to give more detail about what you’re trying to do. @DbLookup does a lot more than you need for a lot of applications, fails in some cases that would not fail if you handled it differently, and it returns data in a form that’s not necessarily ideal for your subsequent processing in LotusScript. Did you need information from all the matching view rows, or just the first? How are you planning to use the values?

6

Subject: RE: DbLookup in Lotus Script

there is only one numeric value in my view, and I need to get that value using Lotus Script.

7

Subject: RE: DbLookup in Lotus Script

Then use NotesView.GetEntryByKey, and read the value out of Columnvalues array. There are perfectly good examples in the Designer help.