First as an introduction you may be receiveing many "uninformed" questions from me, what with Budget cuts our group of programmers have been tasked to rewrite all of our MIS in Visual FoxPro from DbaseV, without benefit of any formal training....so here goes the first one:
I have read as many manuals as I can find and have producted the following SQL progarm to select my data (query) and feed it to a report , but the final output looks as as if no query/selection has occurred....help:
CLOSE DATAB
SELECT Reforg.code, Reforg.dept, Reforg.ccloc, Reforg.ccadmin,;
Reforg.divtitle, Reforg.activeflag, Reforg.bldg, Reforg.delflag;
FROM reforg;
WHERE Reforg.activeflag = "Y";
AND Reforg.delflag = "N";
ORDER BY Reforg.code;
INTO CURSOR Refcmdorg
IF _TALLY < 1
MESSAGEBOX ("No Records selected, No report Generated")
USE
CLOSE DATAB
RETURN
ENDIF
SELECT Refcmdorg
REPORT FORM refcmdorg.frx NOCONSOLE PREVIEW
USE
CLOSE DATAB
RETURN
Any help is most appreciated! Thanks