>>>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?
Yep... works fine if I concatenate it together with + signs, just so long as the strings between each + sign are 255 chars or less. And if I build the whole query string that way to try your test it works... it actually creates the view. I dont get it, I'm still scouring the hacker's quide...
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos