Ask the Expert

@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; 
@Elements(@Explode(salesordernbr)));
@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; 
@Elements(salesordernbr));
    @Prompt([OK];
 "Value of NBR";@Text( NBR))

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

This was first published in November 2004

Back to top