Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Status working By log Manager
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00352333
Message ID:
00357950
Views:
27
Hi Barbara:

Everything looks good except for last line of code I am getting Command contains
unrecognized phrase/keyword. I have a copy of hacker's Guide to Visual FoxPro 6.0 and dosen't give much on setting up PREVIEW logic. Copy my logic is shown below:

cFilt = "Status = 'WORKING'"
SELECT ;
Ilspm ,;
Status ,;
Start ,;
Comp ,;
Ssp ,;
Msr ,;
Avail ,;
Ship ,;
Hull ,;
Num_Chgs ;
FROM Schd ;
WHERE &cFilt ;
INTO CURSOR Rpta ;
ORDER BY 1

REPORT FORM Rpta PREVIEW. --- Command contains unrecognized phrase/keyword.

Question 1: Could I use a field name on ORDER BY 1.

Question 2: INTO CURSOR Rpta ; Field names under Rpta are not the same as in table.
Question 3: REPORT FORM Rpta PREVIEW. --- Should work.
Question 4: Should I list every CURSOR field that should show up in PREVIEW?

Barbara Rpta is my report layout for CURSOR fields. should I list every CURSOR after PREVIEW
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform