Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ammar Hadi
  Where is Ammar Hadi?
 Al-Samawah
 Iraq
 Ammar Hadi
 To: Chad Lee
  Where is Chad Lee?
 Marshall
 Texas - United States
 Chad Lee
 Tags
Subject: RE: Need help with Distinct or Group By
Thread ID: 228143 Message ID: 228426 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Monday, May 18, 2009 8:32:33 PM         
   


> Hi Ammar. I agree with your observation. When I create a program I do exactly what you suggest, I stick with simplicity. This system has been in place over 14 or so years and these tables are for each order. The customer uses our software to make an order and then they upload the order which is the table. It is used to import the order. They are then dissected in the import program. It is a free table that holds order information and may be called in 3 or 4 other programs along it's way through our lab. Then it is never used again unless there is a problem, just backed up.
>
> 80 fields makes it hard to type out a SELECT.

You are going in the right way as far as updating the this system of work is not an option.

Good luck Chad.

Ammar Hadi ................IRAQ

My Foxite Weblog

---------------
I I I really love foxite
___________________________

ENTIRE THREAD

Need help with Distinct or Group By Posted by Chad Lee @ 5/15/2009 8:58:29 PM
RE: Need help with Distinct or Group By Posted by Jon Goad @ 5/15/2009 9:09:19 PM
RE: Need help with Distinct or Group By Posted by Chad Lee @ 5/15/2009 10:25:21 PM
RE: Need help with Distinct or Group By Posted by Stefan Wuebbe @ 5/15/2009 10:37:35 PM
RE: Need help with Distinct or Group By Posted by Chad Lee @ 5/15/2009 10:54:19 PM
RE: Need help with Distinct or Group By Posted by Ammar Hadi @ 5/16/2009 12:11:03 AM
RE: Need help with Distinct or Group By Posted by Chad Lee @ 5/18/2009 8:01:01 PM
RE: Need help with Distinct or Group By Posted by Ammar Hadi @ 5/18/2009 8:32:33 PM
RE: Need help with Distinct or Group By Posted by Anders Altberg @ 5/16/2009 12:54:00 AM
RE: Need help with Distinct or Group By Posted by Chad Lee @ 5/18/2009 8:03:10 PM