Seasons Greetings,

I have a program which the user select the total number of periods (4 weeks per period), then selects the starting date. The program then creates a string for all the desired fields. (this is an old database and the data wasn't normalized).

The code works perfectly as long as the user selects 12 periods or less. If 13 periods is selected, after the query has run, the system generates an error. (VFP caused an invalid page fault in module unknown at 0000:0001f867)

Below is a sample of the code with only 4 weeks (1 period). Lines 2-4 are typically created via a string variable.

When the 52 week query runs, it actually creates the table then generates the error. When I check the file size in Windows Explorer, the size looks like the data is there (15,776,000), but there are no records in the table.

The 2 main files in the query are large. Each table is 76,598,000.

I know the Select statement is correct, because it works, just not for anything over 13 periods (52 weeks).

Any ideas?

Thank in advance,

Scott


select totretl.mvmupc, ;
iif(totunits.jan11=0,0.00,(totretl.jan11/totunits.jan11)) as Jan11,;
iif(totunits.jan04=0,0.00,(totretl.jan04/totunits.jan04)) as Jan04,;
iif(totunits.dec28=0,0.00,(totretl.dec28/totunits.dec28)) as Dec28,;
iif(totunits.dec21=0,0.00,(totretl.dec21/totunits.dec21)) as Dec21;
from totretl, totunits;
where totunits.mvmupc = totretl.mvmupc;
order by totretl.mvmupc;
into table avgret