>Ok, Here's what I have been able to surmise
>
>
>What i am doing is
>
>Create SQL VIEW (lcViewName) as &lcView
>
>lcView is on the order of 3900 bytes long.
>
>Tried a bunch of different things and I think i may be blowing the macro parsing\substitution
>
>What worked was this
>
>lcCommand = "Create Sql View "+lcViewName+" as "+lcView
>Execscript(lcView)
>
>Interesting, Huh
>Any Thoughts?
You can probably try also
set text to lcViewCode textmerge noshow
create SQL View <<lcViewName>> as <<lcView>>
endtext
&lcViewCode ?
or
execscript(lcViewCode)?
The macro is limited to ~8K, so you should not have hit the limit.
If it's not broken, fix it until it is.
My Blog