View Single Post
  #5 (permalink)  
Old August 18th, 2005, 08:53 AM
Mike Lewis Mike Lewis is offline
Registered User
 
Join Date: Jun 2005
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default


EndEffect,

Given that you are using ODBC with a Foxpro database, you could do the following:

SELECT * FROM MyTable GROUP BY Sysno

Note that this is not normally legal SQL syntax, but it works with the Foxpro ODBC driver because the driver is up to date only as of Visual FoxPro 6.0, and that version was very forgiving of this syntax. It should produce the result you want.

Mike