>So try a test:
>
>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?
ick, my machine has gotten weird. I can't seem to store my SQL SELECT to a variable without getting "Command contains unrecognized phrase/keyword" I tried single quotes, double quotes, & square brackets on either end of the string and nada. It doesn't seem to like it once it hits the first UPPER() function :( Time to reboot... I will come back to this first thing tomorrow morning and let you know what I get.
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos