Just above the region. 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 11:56 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Rearrange or ReSort 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 > > > --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
