>Hey all
>
>Is there a caveat missing from the help? I just built a set of command strings like this.
>
>
CLEAR
>CREATE CURSOR csrTest (cField1 c(10))
>lcCmd = ""
>DO WHILE LENC(m.lcCmd) < 4740
> lcCmd = m.lcCmd + "csrTest.cField1 with csrTest.cField1,"
>ENDDO
>?LENC(m.lcCmd)
>lcCmd = LEFTC(m.lcCmd,LENC(m.lcCmd)-1)
>replace &lcCmd. IN csrTest
>
>The number 4740 is differing based on the actual alias and field names. The help says 8192 is the command line length. Obviously that's not completely accurate. What is the maximum length? How can one determine the maximum length before executing?
>
>Thanks
Something else is at work here, not the length of the command, the error for a command that exceeds the max is "line too long" and not "syntax error"
lnLength = 8190
EXECSCRIPT(REPLICATE('*', lnLength))
lnLength = 8191
EXECSCRIPT(REPLICATE('*', lnLength))
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges