In addition to what Peter says:
when you click on the column you want to, put this code
set order to ... in .....(the table or cursor)
this.parent.parent.refresh
Those two lines of code will do what you want. Of course, we are talking
of a grid here, not a browse
Rafael Copquin
On 13/05/2016 13:21, Peter Cushing wrote:
On 13/05/2016 16:44, Joe Yoder wrote:
I need to present information from several tables. I want to enable the
user to click on a column header to control the order in which the
records
are displayed. At this point it does not need to be very polished so a
simple browse with scrolling, column resizing and repositioning, with
control F find will be fine.
I do this with a grid on a form. I create a cursor in the init or
load and set that as the recordsource etc. then fill it with data and
index on the columns you want to be able to set order to. To change
the order just click on the column header and some code behind that
changes the index order. Grids are definitely more work than a browse
but you can do a lot more with them, like the column header click.
Peter
This communication is intended for the person or organisation to whom
it is addressed. The contents are confidential and may be protected in
law. Unauthorised use, copying or disclosure of any of it may be
unlawful. If you have received this message in error, please notify us
immediately by telephone or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3
1RR. Tel:0161 831 3700 Fax:0161 831 3715
London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/26760f54-39d2-48fc-71e3-e09e77f2b...@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.