Using GROUP BY Clause in CRecordset::Open()

[Rajesh_Parameswaran]

Hi all, I have a requirement in which i need to get all the unique user's records from my table. I tried the following query in the Open() function. but it is throwing an error saying: --------------------------- TestDB --------------------------- Error retrieving record. --------------------------- OK --------------------------- I'm using a SDI application with ODBC connectivity. m_pSet->Open(CRecordset::dynaset , _T("SELECT User FROM UserPass GROUP BY User;")); Thanks in Advance. Rajesh

[David Crow]

Rajesh_Parameswaran wrote:

m_pSet->Open(CRecordset::dynaset , _T("SELECT User FROM UserPass GROUP BY User;"));

If you suspect that the GROUP BY clause is the culprit, have you tried the query without it?

---

"A good athlete is the result of a good and worthy opponent." - David Crow

"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne