This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I find myself in need of a SELECT DISTINCT but it doesn't seem to be supported currently. Is there some kind of workaround? I tried going through all the forum posts before but couldn't really find anything. Where is the search for forums? Thanks |
|
|
Hi casualjim, What query are you running that is returning duplicates? Cheers, Andrew. |
|
|
Hi Andrew, It's that I'm running a projection and I know my table may hold duplicate values in that column. I just don't want to have to deal with them in my code if I can just get the list out of the db like that. Cheers |
|
|
Hi Ivan, I've added the ability to specify DISTINCT for projections. Available in tomorrows build. Cheers, Andrew. |
|