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;

See also  11 Effective Keyword Research Tools and Techniques
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist