FIX: SELECT - SQL from Table with 252 Fields Causes Page Fault

   SELECT *, .T. FROM <table>
				

   SELECT * FROM <table> INTO CURSOR <cursorname> NOFILTER
				

MORE INFORMATION

Issuing a SELECT - SQL statement using a table that has more than 251 fields may cause Visual FoxPro to terminate with an Invalid Page Fault. The following code creates a table with 252 fields, inserts a single record, and performs three different SQL SELECT statements. Generally, the first SELECT statement causes an Invalid Page Fault.

Steps to Reproduce Behavior

Create and run a program with the following code:

    fldlist="("
   FOR i = 1 TO 251
        fldlist=fldlist+"fld"+ALLTRIM(STR(i))+" C(5),"
   ENDFOR

   fldlist=fldlist+"FLD"+ALLTRIM(STR(i))+" C(5))"

   valuelst=""
   valuelst=valuelst+REPLICATE("'"+'DATA'+"', ",i-1)+"'DATA'"

   CREATE TABLE manyflds FREE &fldlist
   INSERT INTO manyflds VALUES (&valuelst)

   SELECT * FROM manyflds        && Causes an Invalid Page Fault in VFP 5
   SELECT *,.T. FROM manyflds    && Works fine
   SELECT * FROM manyflds INTO CURSOR temp NOFILTER  && Works fine