Toggle Column Header

Sheldon Stewart wrote:
> What is the command line to change column header (using GRID or Browser) 
after the initial change as been made.

I think you need to be more specific. What *exactly* are you trying to do?

Ken

-- 
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm

When I initially setup the grid or browse I use these line command below to look
like this to display on the column header, but when I toggle to change the index
it will display the objects name.

 with (columns["COLUMN1"].headingControl)
         value = "ASSET No."
      endwith

      with (columns["COLUMN2"].headingControl)
         value = "CATEGORY"
      endwith

      with (columns["COLUMN3"].headingControl)
         value = "ITEM"
      endwith

initially - |  ASSET No.   |    CATEGORY  |   ITEM  No.    |


when I want to change the index the header is displaying the object column
name.

toggle - |    item_no       |  category   |    Asset_no   |

What's is the command line to display it in the same format as the intial
display?


Ken Mayer [dBVIPS] Wrote:

> Sheldon Stewart wrote:
> > What is the command line to change column header (using GRID or
Browser)  after the initial change as been made.
> 
> I think you need to be more specific. What *exactly* are you trying to do?
> 
> Ken
> 
> -- 
> /(Opinions expressed are purely my own, not those of dataBased
> Intelligence, Inc.)/
> 
> *Ken Mayer* [dBVIPS]
> /Golden Stag Productions/
> dBASE at goldenstag dot net
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase/dBASEBooks.htm
> http://www.goldenstag.net/dbase

Sheldon Stewart wrote:
> When I initially setup the grid or browse I use these line command below to
look like this to display on the column header, but when I toggle to change the
index it will display the objects name.
> 
>  with (columns["COLUMN1"].headingControl)
>          value = "ASSET No."
>       endwith
> 
>       with (columns["COLUMN2"].headingControl)
>          value = "CATEGORY"
>       endwith
> 
>       with (columns["COLUMN3"].headingControl)
>          value = "ITEM"
>       endwith
> 
> initially - |  ASSET No.   |    CATEGORY  |   ITEM  No.    |
> 
> 
> when I want to change the index the header is displaying the object column
name.
> 
> toggle - |    item_no       |  category   |    Asset_no   |
> 
> What's is the command line to display it in the same format as the intial
display?

How are you changing the index? Are you deactivating the query and 
reactivating it? If so, don't! It's not necessary. Just change the 
indexName property of the rowset.

Ken


-- 
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm

Sheldon Stewart wrote:
> Yes I'm changing the Index using the indexName property.  But I'm
> changing the order of the column to have the first column to display
> the same as index order I selected.   Just the column header is not
> displaying the header I specify to display.  i.e.  if I initially
> start with 'APPLE' in the first column and 'PEACH' in the second
> column and when I change index order I would get this display on the
> column header 'peach_item' and 'apple_item' (this is my table field
> name/object name)  when I toggle between indexes.   The index is
> working correctly, it is just the header I'm having a problem with.

There's the problem. You're rebuilding the grid. To do that, you have to 
completely overhaul it ... if you look at the grid, you may find that 
you have duplicate columns and lots of other stuff, too ...

Rather than moving the column around, why not just change the color of 
the heading? Or change the text so it's bold and italic, or ...?

Ken

-- 
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm