Since to me you are setting a value of 100 to each row to that particular column. Why instead of doing it in a datawindow do it in the you datasource. It will be instantaneous as soon your dw open it will be there.

Regards,

Clarence.

There is a timing setting for expressions in the painter. I don't have my computer with me today and I don't remember the exact name of it.

My guess it it's the redraws that are taking place on every update that slow it down.

Try adding dw_1.SetRedraw(FALSE) just before the loop starts, and a dw_1.SetRedraw(TRUE) just after the loop.

Please report back and let us know what worked :)

Hi 

PB allocates a new array every time you add an element. So when doing it from top down it's way faster.

for ll_row=dw_1.rowcount()  to 1 step -1 

The question is whether you could fill the rows in the DW simpler either in retrieve or directly instead of putting the values into an array first.

Regards Arthur

Long   ll_noofrows

ll_noofrows = dw_1.RowCount()

for ll_row=1 to ll_noofrows

Try this change

Happiness always

BKR Sivaprakash