Stonefield Software Inks Australian Distribution Deal with Sage

Stonefield Software has signed a distribution deal with Sage Business Solutions to expand the distribution of our popular database reporting software, Stonefield Query, to the Australian, NZ and Pacific Island Market. The new agreement builds on our dramatic growth as the premier end-user focused database reporting software solution in the U.S. and Canada, and expands into the Australian and New Zealand region with a prospective market share of tens of thousands of Sage Software users.

For details, see our press release page or press release itself.

2009 Ceil Silver Ambassador

We are pleased to announce that César Chalom has been selected as the 2009 Ceil Silver Ambassador. He will attend Southwest Fox 2009 and represent the Brazilian VFP community.

César, a software developer from São Paulo, Brazil, has worked with Visual FoxPro since 2003, and is an active member of the Brazilian VFP community. He has attended the Brazilian VFP conference since 2004 and presented sessions at the conference in 2006 and 2008. He is well known to the global VFP community for his contributions to several VFPX community projects, including GDIPlusX and FoxCharts. His blog is an excellent source of technical material on GDIPlusX and other VFP topics.

We are very excited that César can attend Southwest Fox 2009 and know that many attendees are looking forward to meeting him in person.

Controlling DisplayCount in ComboBoxes

The DisplayCount property of the ComboBox class controls how many items the user sees when the ComboBox is dropped down. Normally this is a fixed value, so even though there may be plenty of room to display more items, the user can only see so many and has to scroll to see more.

I like to set DisplayCount dynamically based on how much room there is between the ComboBox's position and the bottom of the screen. I used the following code in the DropDown method of my base ComboBox class to handle this:

* Set DisplayCount to an appropriate value based on how much room there is
* below the form.

local lnHeight
lnHeight = iif(Thisform.ShowWindow = 2 or ;
  (pemstatus(Thisform, 'Desktop', 5) and Thisform.Desktop), sysmetric(2), ;
  _vfp.Height)
This.DisplayCount = max(ceiling((lnHeight - Thisform.Top - ;
  objtoclient(This, 1))/This.Height), 7)