devxlogo

SQL Query in FoxPro Reports

SQL Query in FoxPro Reports

Question:
I am doing calculations in reports using SQL and FoxPro 2.6 for Windows. My SQL query works fine, except for one thing. I want to display information in the reports on the basis on some input. For instance, I have a screen that takes input from a date range and an employee ID.

I have been able to do the date part but I have not been able to display only the information of the employee ID. The employee ID that I am entering has the variable m.id.

The following is the query I wrote:

clear readSELECT Quality.threadin, Quality.picks, Quality.widthfab, Quality.meters,;  Quality.id, quality.meters*quality.picks*.01 as twages; FROM Quality, Employee; WHERE Employee.id = Quality.id; AND Quality.date BETWEEN m.fdate and m.tdate; ORDER BY Quality.id;report form individual.frx previewuse

Where do I add the employee comparison?

Answer:
You are 95 percent of the way there. You just need to add an additional WHERE condition:

 SELECT Quality.threadin,        Quality.picks,        Quality.widthfab,        Quality.meters,;       Quality.id,        quality.meters*quality.picks*.01 as twages; FROM Quality, Employee; WHERE Employee.id = m.id AND Employee.id = Quality.id AND; AND Quality.date BETWEEN m.fdate and m.tdate; ORDER BY Quality.id;

devx-admin

Share the Post: