select distinct in browseform

Questions related to customising nuBuilder Forte with Javascript or PHP.

select distinct in browseform

Postby johan » Sat Apr 13, 2019 7:44 pm

Hi

When I use distinct in query for the browse/edit form, it seems that distinct does'nt work in browse.
What am I doing wrong?

Johan
johan
 
Posts: 268
Joined: Sun Feb 27, 2011 7:46 pm
Location: Belgium

Re: select distinct in browseform

Postby admin » Mon Apr 15, 2019 7:25 am

Johan,

A workaround is to create a temp table in Before Browse.

Steven
admin
Site Admin
 
Posts: 3079
Joined: Mon Jun 15, 2009 9:53 am

Re: select distinct in browseform

Postby johan » Mon Apr 15, 2019 6:32 pm

OK

Thanks for your support.

Johan
johan
 
Posts: 268
Joined: Sun Feb 27, 2011 7:46 pm
Location: Belgium

Re: select distinct in browseform

Postby admin » Sat Apr 20, 2019 8:54 am

.
admin
Site Admin
 
Posts: 3079
Joined: Mon Jun 15, 2009 9:53 am


Return to Custom Code