• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

CGrouse
#1 Posted : Sunday, October 22, 2006 9:23:11 AM(UTC)
CGrouse

Rank: Member

Joined: 6/4/2004(UTC)
Posts: 291

Either I am getting smarter or BVSoftware is making it easier for the little guy to make changes.


A big discussion in 2004 was the sort by problems people had. Sort was defaulted to None, and the user could change to Name or Price but their was no way to tell the defualt to be Price or Name.



Well I figured after reading the post here: http://www.bvsoftware.com/Forums/default.aspx?f=24&amp;m=37779 that the same thing should hold true in BV5. I want to my SQL Server and changed bvc_Product_ByCategory_s --- ORDER BY [color=red>RowNumber</FONT>]SitePrice[/color]



Click Refresh in my webbrowser and Viola, it was sorted by Price.



To the Gurus out there, is this the solution? Or was their a easier way and I am patting myself on the back to quickly?





:)



Chris
Thanks,


Christopher
Noah
#2 Posted : Sunday, October 22, 2006 9:50:49 AM(UTC)
Noah

Rank: Member

Joined: 11/6/2003(UTC)
Posts: 1,903

That's basically it until you want the user to have the choices as well. In that case you would also want to address the drop down list so that it defaults to the same.
Noah
[email protected]
#3 Posted : Monday, October 23, 2006 10:02:07 AM(UTC)
info@cpapsupplyusa.com

Rank: Member

Joined: 7/21/2005(UTC)
Posts: 320

Nicely done.
M. Hall
CPAP Supply USA

http://www.cpapsupplyusa.com
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012