>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.
Hey Erik,
Let me clarify that statement for you, maybe I found something helpful here for eView but I doubt it. Say I concatenate that whole monster SELECT statement into lcSQL variable. Then try:
lcViewCode="CREATE SQL VIEW MyView AS " + lcSQL
&lcViewCode
It creates the view just fine, both at command window and in a prg. The trick seems to be concatenating that string together. In eView are you storing the value of the form control as is to lcSQL ?
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos