Hi All,

I'm not very familiar with SQL Syntax. I've been trying to figure out what's wrong with the following statement:

SELECT nixies, NixieEng, cnt(*) FROM DBF() ORDER BY nixies GROUP BY nixies

The field nixies is a c(30) field and NixieEng is a memo field. FoxPro keeps telling me that the 'GROUP BY clause is missing or invalid'.

Also, what other SQL type functions are available other than cnt(*)?

Aloha,

James