>Is this an oddball error for VFP 5.0a, or is it something I can fix?
>
>Many times I get the "Compiled code for this line is too long (Error 1252)" error when trying to run a query or a program with a SQL SELECT statement in it. The SQL statements are NOT very long (no more than 6 or 7 lines of code). FWIW: I can run code I ran under FPW and get this error when I never did under FPW. Weird...
>
>What's going on?
>
>TIA:
>- Gerry

Gerry,

Maximum # of characters per command line is 8,192, so I suppose you did not hit the limit. But, the Maximum size of character fields is 254. So if you define a SQL statement in the control source of a combo, by example, you'll soon hit the limit.

If this is the case, you could base your combo on a view.

This subject has been discussed several times here and you might want to do a search on "1252" and check what it gives.

José