Subject Re: grid column index From Ken Mayer <dbase@nospam.goldenstag.net> Date Fri, 14 May 2021 21:21:41 -0700 Newsgroups dbase.getting-started On 5/14/2021 3:08 PM, Charlie wrote: > Curious to know what others do in regard to a column index in a grid.  Is there a way of making each header active so if you click on it, the grid indexes on that column/field? > > I have a form set up with an 'index' button above each header that you push in order to index on that column/field. > > I've coded in php where you can have the column header itself be the index button.  Just curious if this is possible in dbase grids or if there is a better way to do it. > > Thanks for any comments. The dBASE grid allows this, but it takes a bit of work ... first, does the column have an index? If not, are you using an "order by" clause for the sql select? Unfortunately, help isn't all that helpful on this. The headingControl doesn't have an onClick event handler, but you can assign code to the headingControl's onLeftMouseUp event. From there you can, if you have an index tag for the field displayed, change the rowset's index:     // reference to form.rowset:     oRowSet = form.Grid1.dataLink     oRowset.indexName := "Title" But you have to have an index named "Title" and all that. Hope this gets you started. There's code in a the dUFLP in the file GridColumnIndexChange.cc that you may want to look at. Ken -- *Ken Mayer* Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm