>We are getting a an error "Coompiled code too long"
>
>This is occurring when we issue a
>
>&cmd
>
>where cmd is a sql select statement. A very nasty sql select statement built on the fly. How long can this statement be before we bomb?
>
>Ken Wardwell
I think in earlier versions of Foxpro the macro limit was 255 chars. Now it's 8192 chars.
You may want to use select &lcFieldList from &lcTableList where &LcWhere assuming that none of these exceeds 255. If it will, you may need to divide it further...
If it's not broken, fix it until it is.
My Blog