You receive a "Compiled code for this line too long" error message in Visual FoxPro

WORKAROUND

• Use an ON ERROR routine that traps errors 18 (Line too long), 1252 (Compiled code for this line too long), and 1812 (SQL statement too long).
• Replace literal strings with variable references. This would also work for date literals (for example, {12/30/93}) and many numeric literals (for example, 4.5).
  
  For example, in the following SELECT-SQL command, the quoted text strings, "Allied Products" and "Microsoft Corp.", cannot be tokenized any further:

        SELECT * FROM customer ;
             WHERE company = "Allied Products" or company = "Microsoft Corp."
  						

  To work around this behavior, create a set of variables such as the following:

        m.company1="Allied Products"
        m.company2="Microsoft Corp."
  						

  Then, change your SELECT command line to the following:

        SELECT * FROM customer;
             WHERE company=m.company1 or company=m.company2
  						

  In many cases, this command will tokenize smaller than the original command.
  
  Note This method does not work for small integers (less than 256) because the size of a tokenized 1-byte integer is the same as the size of a tokenized variable reference.