>I don't use reserved VFP keywords as field name even reserved mySQL keywords
>It works if I split into a few statement with the same field names
>
>
I also wanted to suggest to use
text to lcCommand noshow
mylongcompexcommand
endtext
At least it will make this command more readable /easy to maintain and you would not run into string literal limitation.
If it's not broken, fix it until it is.
My Blog 
