?
Solved

Displaying Query Results

Posted on 2003-11-06
4
Medium Priority
?
218 Views
Last Modified: 2010-07-27
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
Comment
Question by:marom279
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 

Accepted Solution

by:
AW1712 earned 200 total points
ID: 9700949
SELECT distinct *
FROM AllCustomers
ORDER BY AllCustomers.Name
INTO CURSOR stam
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is about my first experience with programming Arduino.
The SignAloud Glove is capable of translating American Sign Language signs into text and audio.
Six Sigma Control Plans
Introduction to Processes

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question