My.ADVISOR.com Sign-In
ID
Password

Member Center / Sign-Up
   
SUBSCRIPTION STATUS
If you are a subscriber to this publication, sign-in to access locked articles. To subscribe or renew go to www.AdvisorStore.com.
Go to Article
Advanced Search 

ADVISOR TIPS

Test Lotus Formula Language

This toolbar button gives you a way to test Lotus Formula Language.

By David Lundy, Programmer/Analyst, Shepherd Center IS


Here's a handy toolbar button to have when testing out code: the Formula Language Evaluator.

Type/paste the code you want to test into the dialog, and it presents the results (as best it can) in another text box.

Put the following code behind a toolbar button:

result := @Eval ( @Prompt ( [OkCancelEdit]; "Formula evaluator"; "Enter the formula to evaluate:"; "" ) );

@Prompt([Ok]; "Results window"; @Text(@Implode(result; " ~ " )))

Note that this code displays text lists with a tilde character (~) as a separator between items for functions such as @UserRoles or @DBColumn.


Printer-friendly
page layout

What do YOU think about this topic? Share your advice and thoughts using this form.

Your Name

REQUIRED : PUBLIC

Your E-Mail

REQUIRED : PRIVATE

Job, Company

OPTIONAL : PUBLIC

City, State, Country

OPTIONAL : PUBLIC

Your Web Site

OPTIONAL : PUBLIC

Your Comment

Please help everyone by keeping your comments on-topic, using clean language, and not defaming or making personal attacks.


Your e-mail address is required, but it will not be displayed to the public or given to anyone. See our Privacy Policy. Comments become visible after they pass our spam filter, and spammers and abusers are permanently blocked. Please report spam or abuse.

ARTICLE INFO

Web Edition: 2003.05.12, Doc #12385

FREE ACCESS FREE ACCESS

Keyword Tags: Application Development, Development, IBM, IBM Lotus, IBM Lotus Notes, IBM WebSphere, Lotus Formula Language, Programming, Software Development, Testing

Use of this or any other site, content, product or service of Advisor Media constitutes acceptance of Terms of Use.
Portions copyright ©1983-2010 Advisor Media, LLC. All Rights Reserved.
Reuse or reproduction of any portion or quantity of Advisor Media's copyrighted content, in any form, for any purpose, requires written permission.
ADVISOR®, the ADVISOR logo, and other names and logos that incorporate ADVISOR are registered trademarks, trademarks or service marks of Advisor Media, LLC in the United States and/or other countries.
Other trademarks are used for identification, editorial or descriptive purposes and are the property of their owners.
Hosted by Prominic.NET Website powered by
LOTUS SOFTWARE
oa LUNDD001 posted 2003-5-12 mod 03/08/2010 03:10:13 AM ztdbms/ztdbms
domino-144.advisor.com my.advisor.com 03/10/2010 03:52:40 PM