asked on 4/28/2006

formula script equivalent

What would be the script equivalent of this formula?

@Text(@DbLookup("Notes":"Nocache" ; "Servername":"database.nsf"; "SOLV" ; batch ; 2 ));
@If( @IsError(so); "na"; so);

Lotus IBM

Last Comment

David Schmalzer

5/3/2006

David Schmalzer

4/28/2006

ASKER

And, will I be able to tag it on to the end of an existing script?

HappyFunBall

4/28/2006

Dim s as New NotesSession
Dim db as NotesDatabase
Dim view as NotesView
Dim doc as NotesDocument
Dim key(0) as String

Set db = s.CurrentDatabase
Set view = db.GetView("SOLV")
key(0) = batch
Set doc = view.GetDocumentByKey(key, True)
If doc Is Nothing Then
Messagebox "na"
Else
Messagebox so
End If

I'm not sure of the context of this code, so you may want to change the messageboxes into return values of a function or to set some fields on a form, etc.

mbonaci

4/28/2006

Hi schmad01,
modify this code:

http://searchdomino.techtarget.com/tip/1,289483,sid4_gci1160526,00.html?FromTaxonomy=%2Fpr%2F283841

Hope this helps,
Marko

HappyFunBall

4/28/2006

No reason you can't tag it on the end of a script. But like I said above, you'll need to add more code depending on what that @formula was returning to. If that @formula was in a form field, then you'll need to add some code to set that field via the script.

Sjef Bosman

4/28/2006

I think the eaxct equivalent would be
""

I assume your Formula is not correct, semantically...

ASKER CERTIFIED SOLUTION

HappyFunBall

4/28/2006

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

David Schmalzer

4/28/2006

ASKER

:) It works, I have it in a computed field, computed when composed. I just wanted to put it at the end of another script.

mbonaci

4/28/2006

schmad01,
Notice "OR" in the definition from designer's help:

@DbLookup( class : cache ; server : database ; view ; key ; fieldName ; keywords ) or
@DbLookup( class : cache ; server : database ; view ; key ; columnNumber ; keywords)

Marko

HappyFunBall

4/28/2006

Unless I'm missing something, schmad01's formula fits the first type of @DBLookup. What were you getting at Marko?

mbonaci

4/28/2006

It works by accident :)
It has an error, he has put fieldName and columnNumber in it, he merged two versions of formula.

The lucky part (but I would rather say it's unlucky) was that Lotus thought number 2 is keyword so he just ignored it.

Keywords are:
[FAILSILENT] [PARTIALMATCH] [RETURNDOCUMENTUNIQUEID]

Marko

HappyFunBall

4/28/2006

"keywords" are optional, right? If so, check the number of parameters again. The formula looks right to me.

Steve Knight

4/28/2006

Of course if you are really lazy....

dim batch as string
batch = doc.batch(0) or whatever
Evaluate | @Text(@DbLookup("Notes":"Nocache" ; "Servername":"database.nsf"; "SOLV" ; | & batch & | )); |

Steve

Steve Knight

4/28/2006

(an obviously doing something with the result of evaluate.... i.e. result=evaluate | sdsdjksjskd |

David Schmalzer

5/3/2006

ASKER

Thanks alot.