RowID and ORA-00937: not a single-group group function

I have been facing this error for quite sometime now. No its not that I have not properly used group by function. My SQL reads something like this in error log file

Select nvl(max(id_no),0) id_no, Desig.ROWID from ......

But my actual SQL query in VB does not have a Desig.ROWID . Then from where did this ROWID got inserted ?
This is what actually happens :

When I looked into my VB code, I found while making a recordset, that the locktype used was adOptimistic. This mode is used when we need to read the data from database, modify it then again save it back to database. So he needs to know which row has to be updated which results in adding a rowid to query. So the solution to this problem is to use readonly mode.




Tags : RowID, Oracle, ORA-00937, single-group