Issues with both Supercontrol Alphabet Buttons Search and Multi-State Button

[davej]

Running Win 7 Pro (64 bit) - A5V10 Build 4309-3702

I've just run into two quasi-related issues.

Issue 1:

I've have a Multi-State Button on a form. To the immediate right of the Mult-State Button, I have a columnar browse to display the values (last names) that are returned when any of the alpha buttons are clicked. This part works fine. The problem occurs when there are more names than will fit in the browse with the height I've given it. A vertical scroll handle appears and when I try to scroll down to see more of the returned names, the displayed names go from only those that start with the selected letter to a list displaying all records in the table. (ex: I click 'S' in the multi-state button and all the last names that start with 'S' are displayed. However, the number of names starting with 'S' is greater than what is displayed and when I grab the vertical scroll handle, the list changes to display all of the records in the .dbf table.

Issue 2:

When I replace the Multi-State Button (in Issue 1 above) with an 'Alphabet Buttons' Search Supercontrol, it works fine, except I would like to display the letters in multiple columns, but I can't find where to do that. In the xdialog that controls the appearance, the only choices are horizontal or vertical but does not include multiple columns.

Any suggestions on either or both of these?

Thanks,

Dave

[natn1251]

Re: Issues with both Supercontrol Alphabet Buttons Search and Multi-State Button

Hello Dave
It appears as if the Supercontrol Alphabet Button will not group as you want. On the MultiState button I created a form with a browse that had 150 records and set a to return 66 records. The Browse window only displayed 7 records. when I scrolled the query stayed in tact. Here is the code I used.

if MyBtn = "Show All" then
	DIM records_found as N
	records_found = topparent.queryrun(".t.","","","No","",.f.)
else	
DIM records_found as N
records_found = topparent.queryrun("Left(Emptyfield,1) = Var->MyBtn","","","No","",.f.)
end if
parentform.Refresh_Layout()

Hope this helps


Nick

[davej]

Re: Issues with both Supercontrol Alphabet Buttons Search and Multi-State Button

Nick,

Thanks. I'll try your code as soon as my plate clears up a bit.

Dave