General information
Category:
Reports & Report designer
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only