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

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


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

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


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