Sorting Columns 1

[siraj777]

There are 5 datawindows. The first datawindow is sorted on column A by selecting it from sort dialog box. (dw_1.Setsort(null) - columns are selected dynamically) How to sort the remaining 4 datawindows on the same column/s without prompting the dialog.

In other words how to get the column/s sorted on first datawindow.

 

[dynamicjourney2001]

Hi, you can define the sorted columns in the datawindow painter menu Rows>Sort , or you can use ORDER BY keyword in your Query.
Hope this helps.

Have fun!

 

[ThierryR]

Hi,

try the following :

dw_1.Setsort(null)
ls_sort = dw_1.Describe("DataWindow.Table.Sort&quot
dw_2.SetSort(ls_sort)
dw_2.Sort()

Hope it will help

Thierry

 

[PowerObject]

If the result-sets are similar, you may use the ShareData() on all the dw's which is simply automatic.

Otherwise, after you sort the dw_1:

//////////////////////////////////////////////////
string ls_Sort
//
ls_Sort = dw_1.Object.DataWindow.Table.Sort
//
IF ls_Sort <> &quot;?&quot; THEN
//
dw_2.SetSort( ls_Sort )
dw_3.SetSort( ls_Sort )
dw_4.SetSort( ls_Sort )
dw_5.SetSort( ls_Sort )
//
dw_2.Sort()
dw_3.Sort()
dw_4.Sort()
dw_5.Sort()
//
END IF

//////////////////////////////////////////////////

Hope this helps...

---
PowerObject!
-----------------------------------------

http://Groups.Yahoo.com/group/PowerObject

PowerBuilder / PFC Developers' Group