Use of DISTINCTROW with Foxpro SQL

[Damby]

I am writing queries to get information from Foxpro dbf tables using DISTINCTROW but I always get an ODBC error stating that I am using an unrecognized word.

What word could I use to achieve the same thing.

If anyone knows where I could find information on Foxpro's SQL on the net, please let me know.

Thanks.

 

[fluteplr]

select distinct * from mytable