GetText with seq() problem

David Thompson dthmpsn1 at illinois.edu
Fri May 23 06:41:47 PDT 2008


>I'd like to take this:
>
>seq() ¾ 100
>
>which I can use manually in a FormulaFindSelect to limit the length of a list
>
>and incorporate it into a GetText dialog so the 
>user can input the number. But not sure how to 
>do it. I imagine it would have a command and 
>then:  seq() ¾ howMany
>
>but my various attempts all produce errors.
>
>So I'm stuck here:
>
>local howMany
>howMany=150"
>
>GetText "Choose the top _______ items:",howMany

Make that

local howMany
howMany="150"

GetText "Choose the top _______ items:",howMany
howMany = val(howMany)

Then you will be able to use

Select seq() <= howMany

to select the requested number of records. 
Without that val( function, you would have been 
comparing a number to text, and you would have 
gotten a type mismatch.

Dave


More information about the Qna mailing list