Page 1 of 1

SELECT DISTINCT doesn't work on browse form

Posted: Sat Aug 23, 2014 7:39 am
by guscastro
I should be missing something.
I put this code below into the SQL box of a form

Code: Select all

select distinct `title_type` FROM `la_contacts` 
I tested the code direct on the MYSQL panel and it works perfect but on the nu app the DISCTINCT is ignored and it browse all the records.
Please help
Image

Re: SELECT DISTINCT doesn't work on browse form

Posted: Wed Aug 27, 2014 6:09 am
by admin
guscastro,

Your sql needs to contain the Form's Primary Key

Steven