line is too long in eval or &

I have a very long string that i am trying to evaluate, and it returns.
"LINE IS TOO LONG". what are the limitations for eval or macro substitution?


thanks,
Marty

Rush
Fri Mar 07 14:07:08 CST 2008

Marty wrote:
> I have a very long string that i am trying to evaluate, and it returns.
> "LINE IS TOO LONG". what are the limitations for eval or macro substitution?
>
>
> thanks,
> Marty
>
Check your help file under "System capacities." In VFP 9, it is 8,192
characters.

- Rush

Stephen
Fri Mar 07 14:06:57 CST 2008

vfp 9 help gives this for error 18 'Line is too long'

The maximum length for a command line (8,192 bytes) has been exceeded.

a.. Macro substitution might have caused the line to expand beyond the
8,192-byte limit.


Sincerely

Stephen

"Marty" <Marty@discussions.microsoft.com> wrote in message
news:33DBFF69-D41E-4697-8264-8C968B708B3A@microsoft.com...
>I have a very long string that i am trying to evaluate, and it returns.
> "LINE IS TOO LONG". what are the limitations for eval or macro
> substitution?
>
>
> thanks,
> Marty

Darwin
Sat Mar 08 01:06:29 CST 2008

If you can use execScript(..)

"Marty" <Marty@discussions.microsoft.com> wrote in message
news:33DBFF69-D41E-4697-8264-8C968B708B3A@microsoft.com...
>I have a very long string that i am trying to evaluate, and it returns.
> "LINE IS TOO LONG". what are the limitations for eval or macro
> substitution?
>
>
> thanks,
> Marty

Man-wai
Sat Mar 08 07:54:55 CST 2008

Marty wrote:
> I have a very long string that i am trying to evaluate, and it returns.
> "LINE IS TOO LONG". what are the limitations for eval or macro substitution?

Would like to see it... :)

--
@~@ Might, Courage, Vision, SINCERITY.
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Xubuntu 7.04) Linux 2.6.24.3
^ ^ 21:54:01 up 10 days 7:42 0 users load average: 0.02 0.04 0.00
? ? (CSSA):
http://www.swd.gov.hk/tc/index/site_pubsvc/page_socsecu/sub_addressesa/

Steve
Sun Mar 09 14:38:45 CDT 2008

"Marty" <Marty@discussions.microsoft.com> wrote in message
news:33DBFF69-D41E-4697-8264-8C968B708B3A@microsoft.com...
>I have a very long string that i am trying to evaluate, and it returns.
> "LINE IS TOO LONG". what are the limitations for eval or macro
> substitution?
>
>
> thanks,
> Marty

I don't know if this still works, but in the past we have worked around
this problem by breaking up the macro into several macros, e.g.,

&thiscommand && error

&thiscommand_1&thiscommand_2 && works

In our case, it was long SQL SELECT statements, so we'd take one memvar
for each big clause or otherwise try parse it out in a maintainable
manner.

-S-