Hi Emmitt,
This sounds interesting.
The answer to the second question works, I can retrieve the part no.
For the rest of it --
I will try this tomorrow but--
What do you mean "place 2 buttons over the columns"
do you mean within the region (how?) or above the region?
Bernie
----- Original Message -----
From: "Emmitt Dove" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, June 30, 2008 10:58 PM
Subject: [RBASE-L] - RE: Rearrange or ReSort
Bernie,
Answer to second question first: Use a form expression in the format:
Varname TYPE = (partno)
Whenever the user clicks on a different row the variable "varname" will
take
on the value in the column partno.
Answer to first question: The way I've handled this with a region is to
place two buttons over columns I want sortable, one with an up arrow and
one
with a down arrow, stacked on top of each other. They have different
component IDs. I base the region on a view. The on-after-start code
hides
the up arrows and makes the down arrows visible (indicating the current
sort
is in ascending order.)
The code behind the arrows will:
a) PROPERTY TABLE tablename 'CLOSE'
b) DROP VIEW viewname
c) CREATE VIEW viewname with the desired sort order
d) PROPERTY TABLE tablename 'OPEN'
e) hide the opposite direction arrow, show the new arrow
f) RECALC VARIABLES
If you want to get real fancy, you need to remember which row the user was
on when they clicked the sort button and then reposition to that row after
step d) above.
Emmitt Dove
Manager, DairyPak Business Systems
Evergreen Packaging, Inc.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
(203) 643-8022
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard
Lis
Sent: Monday, June 30, 2008 9:42 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Rearrange or ReSort
If I bring up a form with a region that has several columns and then I
want
to re-sort them by any of those columns, how might I accomplish this?
After re-sorting, I need to capture the row (Part Number of the row) that
the user selects.
I am thinking something along the lines of when you do a browse and click
on
a column heading, it sorts the rows by that column. Or if I use the
Browse
command, is there a way for the user to click on a row so that I can get a
return value to know which row they want?
Bernie Lis
