[RBG7-L] - Sorting Data in Scrolling Region (was Ref: DB Lookup Listbox)

[A. Razzak Memon]

At 05:30 PM 3/24/2005, Jan Johansen wrote:

Now if sorting the information in a scrolling region was as easy.
I've been playing around trying to use a bit button to sort the
region while the form is open.
Haven't quite found the trick yet.The region is a secondary table.

Jan,

Here's how:

01. Define the Scrolling Region based on a TEMPORARY table/view

02. Define Variable Check Boxes or Radio Buttons to return user
    selected sort criteria

03. Use the PROPERTY command to first CLOSE the record set

    Example:
    PROPERTY <FormTableName> 'CLOSE'

04. Re-Define the sorted TEMPORARY Table/View accordingly

05. Use the PROPERTY command to OPEN the record set

    Example:
    PROPERTY <FormTableName> 'OPEN'

For complete details along with source code of two sample applications:

http://www.razzak.com/sampleapplications  (Items 022 and 023)

Item 022: Universal Data Browser

Item 023: Universal Data Browser (Part II)

Enjoy and make sure to have fun!

Very Best R:egards,

Razzak.