Specifying Nulls First when retrieving a collection

Posts   
 
    
Matt46
User
Posts: 1
Joined: 07-Aug-2008
# Posted on: 07-Aug-2008 18:11:30   

Hi

When selecting data from Oracle via SQL, its possible to add NULLS FIRST to the order by clause so that null values are listed first.

Is this possible through llblgen (version2.5) ?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 08-Aug-2008 06:44:09   

I'm afraid that isn't possible for v2.5.

If you would upgrade to v2.6, you can around that this way: http://llblgen.com/TinyForum/Messages.aspx?ThreadID=13532

Or maybe sorting in-memory: http://llblgen.com/TinyForum/Messages.aspx?ThreadID=13944&StartAtMessage=0&#77669

David Elizondo | LLBLGen Support Team