Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Status working By log Manager
Message
From
05/04/2000 15:25:17
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00352333
Message ID:
00355878
Views:
37
>Hi Ed
>
>Thanks for the info. Ed I compiled the program now I am getting Command contains unrecognized phrase/keyword. On the last line of code.
>
>INTO CURSOR Rpt1 order by 1

No - it's the select

>>cFilt = "Status = "WORKING' "
>>SELECT
>>Lispm ,;
>>Status ,;
>>Start ,;
>>Comp ,;
>>Ssp ,;
>>Msr ,;
>>Avail ,;
>>Ship ,;
>>Hull ,;
>>Chgs ;
>>FROM Schd;
>>WHERE &cFilt

this should read WHERE & cFilt ;

so that the remaining part of the Select is included in the command.

>>INTO CURSOR RptData Order by 1


>
>Select Rpt1
>REPORT FORM Rpt1 Preview. --- This line of code is Highlighted
>
>Preview must be in error. Where can I find info on REPORT FORM XXXX Preview.
>
>Can I find MSDN library on FoxPro Cd. I looking for examples of SQL statements under "SELECT - SQL Command.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform