Column Header Sorting and MS SQL

Hello all,

I am having a problem with the ABC Browse Template column header
sorting option.  It works as long as every record in the browse has a
value for the column being sorted but if any of them are blank (null),
the functionality is inconsistent.  Sometimes it hides those records
and sometimes it shows them.  I believe the pattern is related to what
I have highlighted.  If I select a record that has a blank value for
Entry Date and then try to sort by Entry Date, all of the records
show.  If I select a record that has a non-blank value for Entry Date
and then try to sort by Entry Date, it excludes all of the items that
are blank.

Any suggestions?

Thanks,

Troy Frech

Hi Troy,

You will get faster answers on ---  news.softvelocity.com  ---  newsgroup.

--
Best Regards,
Earl R Coker
ksasales AT machlink DOT com
www.kwiksystems.net
www.kwiksystems.com
www.kwiksystems.net/appshell/index.htm
www.kwiksystems.com/clarion.htm (BigTamer(tm) Templates)


"TroyFrech" <tfrech@synovacorp.com> wrote in message
news:b02d61b5-690f-4951-b9cf-f4ec3d0344b9@a22g2000hsc.googlegroups.com...
> Hello all,
>
> I am having a problem with the ABC Browse Template column header
> sorting option.  It works as long as every record in the browse has a
> value for the column being sorted but if any of them are blank (null),
> the functionality is inconsistent.  Sometimes it hides those records
> and sometimes it shows them.  I believe the pattern is related to what
> I have highlighted.  If I select a record that has a blank value for
> Entry Date and then try to sort by Entry Date, all of the records
> show.  If I select a record that has a non-blank value for Entry Date
> and then try to sort by Entry Date, it excludes all of the items that
> are blank.
>
> Any suggestions?
>
> Thanks,
>
> Troy Frech