• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 233
  • Last Modified:

Displaying Query Results

Hi,


In Fox Pro, I have to create a report that displays sorted records from a table.
I wrote the following query :

SELECT *;
FROM AllCustomers;
ORDER BY AllCustomers.Name;
INTO CURSOR stam

REPORT FORM e:\michael\MyFoxProFiles\allcustomers2.frx preview

The problem is that the report displays only the first record may times as the records number in the table.

Please tell me how to fix this problem.

Thanks
Michael
 
0
marom279
Asked:
marom279
1 Solution
 
AW1712Commented:
SELECT distinct *
FROM AllCustomers
ORDER BY AllCustomers.Name
INTO CURSOR stam
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now