Distinct record

Posts   
 
    
Posts: 97
Joined: 29-Apr-2009
# Posted on: 31-Aug-2009 09:29:04   

Hello All,

i am using llblGen 2.6 and self servicing and my sql database

i want to execute the following query in llbl.

select DISTINCT Classification from jobdetails;

so how can i write code in llblGen with self servicing

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 31-Aug-2009 09:59:06   

Fetch a DynamicList of one field. (please check the docs). And for the Distinct part, just set the AllowDuplicates parameter of the typedListDao.GetMultiAsDataTable() to false

Posts: 97
Joined: 29-Apr-2009
# Posted on: 01-Sep-2009 08:13:13   

Walaa wrote:

Fetch a DynamicList of one field. (please check the docs). And for the Distinct part, just set the AllowDuplicates parameter of the typedListDao.GetMultiAsDataTable() to false

Thanks walaa, i will try this one.