>Hi Barbara:
>
>I started typing in code under code and programs in Visual FoxPro under Project Manager.
>
>cFilt = "Status = "WORKING' "
>SELECT
>Lispm ,;
>Status ,;
>Start ,;
>Comp ,;
>Ssp ,;
>Msr ,;
>Avail ,;
>Ship ,;
>Hull ,;
>Chgs ;
>FROM Schd;
>WHERE &cFilt
>INTO CURSOR RptData Order by 1
>
>Select RptData
>Report form MyReport Preview.
>
>1. Question why are status and Comp fields are showing up in blue. (code command window)
They're VFP reserved words. While VFP is working out in this case that they're field references, the syntax coloring parser is not as smart - it sees a string that matches a pattern of a reserved word, it colors the keyword appropriately. Don't run a beautifier against this, since many beautifiers use similar principles and might expand reserved word abbreviations to match their full frmat.
>2. RptData is actually the report formats created by report wizards?
No, it's a cursor - a temporary table that goes away after you close it - containing the data matching the WHERE clause as specified in your filter condition. If there's an index on status, the query you pose has a danger in that it's a query against a single table; if the query is fully optimizable, the result might be a filtered view - actually a direct reference to the underlying table wth a specialized filter and indexing order applied. These have a nasty tendency to have unreliable and unpredictable wierdness in reports in conjunction with PREVIEW - you can remove the danger by adding a NOFILTER clause.