Problem solve Get help with specific problems with your technologies, process and projects.

@Prompt displays nothing for NBR field

What is wrong with the following code? The @Prompt displays nothing for the NBR field. Salesordernbr is a multi-value field with "A";"B" assigned to it. What am I doing wrong?
nbr:=@If(salesordernbr = ""; 0; 
@Prompt([Ok]; "Value of NBR"; NBR); 
The @Explode is not needed for a multi-valued field, but the issue is that @Prompt requires text. So the following code should do what you want.
    nbr:=@If(salesordernbr = ""; 0; 
 "Value of NBR";@Text( NBR))

Do you have comments on this Ask the Expert question and response? Let us know.

Dig Deeper on Lotus Notes Domino Formula Language

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...