I have this code:

SELECT Argltr
SUM amount TO lnAmount FOR (LEFT(glcode,1) $ "DGN") AND (BETWEEN(invdate,pdBegin,pdEnd)) 

SELECT "X" AS metal, company, amount, netwgt, IIF(netwgt=0,000.00,ROUND(MTON(amount)/netwgt,2)) AS priceper, ;
       IIF(lnAmount=0,000.00,ROUND((MTON(amount)/lnAmount)*100,2)) AS percsale ;
FROM argltr  ;
INTO CURSOR ccstc ;
WHERE (LEFT(glcode,1) $ "DGN") AND (BETWEEN(invdate,pdBegin,pdEnd)) ;
ORDER BY amount DESC

pcTitle = "TORRANCE CASTING INC."+CHR(10)+ ;
          "CORP. SALES TO CUSTOMER"+CHR(10)+ ;
          "BY SALES $$"+CHR(10)+ ;
          "FOR "+DTOC(pdBegin)+" THRU "+DTOC(pdEnd)

REPORT FORM (gc_adrvprg+"ccstc") TO PRINTER PREVIEW

When I run it the first time, it runs fine. But if I run it again, it crashes on the SQL SELECT. If I comment out the report call, I can run it over and over with no problems. But as soon as that report runs, the next time it hits the SQL, it crashes. By crashes, I mean crashes VFP.

I don't have a clue what could be wrong. Any ideas?

Thanks,

Michelle