How to Allow Empty Fields in Visual FoxPro Crosstab Queries

MORE INFORMATION

Step-by-Step Procedure

1. Open Vfpxtab.prg and save it as Myxtab.prg.
2. In Myxtab.prg, search for SET NULL ON and change it to SET NULL OFF.
3. Search for this:

      IF ISNULL(EVAL(FIELD(m.i)))
         LOOP
      ENDIF
   						

   Replace it with this:

      cFieldName = field(m.i)
      IF ISBLANK(&cFieldName)
         LOOP
      ENDIF
   						

4. In the Command window, type the following commands:

       _GENXTAB = "C:\VFP\MYXTAB.PRG"
       MODIFY COMMAND NULLTEST.
   						

5. Place the following code in Nulltest:

          SELECT Customer.city, Customer.contact,;
          COUNT(Customer.maxordamt);
          FROM tastrade!customer;
          GROUP BY Customer.city, Customer.contact;
          ORDER BY Customer.city, Customer.contact;
          INTO CURSOR SYS(2015)
          DO (_GENXTAB) WITH 'Query',.t.,.t.,.t.,,,,.t.,1
   
          BROWSE NOMODIFY