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