>
>Passing parameters doesn't have a practical limit. The following works without problem:
>
>
>clear
>x = REPLICATE("abc", 100000)
>function_a(x)
>
>FUNCTION function_a(tcpar)
> ? LEN(x)
>ENDFUNC
>
>
>(Length of parameters = 300,000)
>
>In any case, it is worthwhile to try to check each aspect separately, e.g., parameter passing, macro expansion, SQL command.
>
>For example, you can build the entire SQL command - you don't even need macro expansion for this - as a string, and then execute it all at once. For example, if the list of fields is variable:
>
>
>lcCommand = "select " + lcFieldList + " from MyTable"
>&lcCommand
>
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham