>>At the command window, load your view SQL into a variable prefaced with "CREATE SQL VIEW MyView AS " + lcSQL, and macro execute it using &lcViewCode. Do you get an error?
>
>Well shoot Erik, reboot did no good & now this is beginning to bug me. When trying
lcSQL="SELECT...." from the command window, I get that "Command contains unrecognizable phrase/keyword" error if the string I'm trying to store to the variable is greater than 255 characters.
>
>Now granted the entire SELECT statement is longer than max # of characters per command line. But Dagnabbit! System Capacities in Help Info say max number of characters per string or memory variable is 16,777,184. VFP6 SP3.... I dont get it.
Have you tried building it a chuck at a time?
Erik Moore
Clientelligence