Hey Sarwar after writing query as
Cursor c = sampleDB.rawQuery ("SELECT _id,RoomName,
group_concat(SwitchFullName,'\n')as SwitchFullName FROM SwitchTable
GROUP BY RoomName",null);
It works. Thank you very much.
On Dec 14, 3:05 pm, Sarwar Erfan <[email protected]> wrote:
> *Ignore previous reply.* There was a type due to copy paste: Use this:----
>
> Cursor c = sampleDB.rawQuery ("SELECT RoomName,
> *group_concat(SwitchFullName,'\n')
> as SwitchFullName* FROM SwitchTable *GROUP BY RoomName*",null);
>
> Regards
> Sarwar Erfan
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
