Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Visual FoxPro
Expertise: Beginner
Sep 13, 1999

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 read

SELECT 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 preview

use
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 Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date