Sort An Array Using Datastore In PowerBuilder

Sort An Array Using Datastore In PowerBuilder
We create a small datastore and use it to sort our array.

datastore lds_temp

String ls_err

Integer i

Long ll_array[] = { 2 , 3, 6, 5 }

String ls_dsdef = 'release 6; datawindow() table(column=(type=long name=a dbname="a") )'

lds_temp = Create datastore

lds_temp.Create(ls_dsdef, ls_err)

// put the array in the datastore

lds_temp.Object.a.current = ll_array

lds_temp.SetSort("a ASC")

lds_temp.Sort()

// get back the array

ll_array = lds_temp.Object.a.current

For i = 1 To UpperBound(ll_array)

MessageBox("Infor", String(ll_array[i]))

Destroy lds_temp

Good Luck!

PowerBuilder Tips & Tricks

November 21, 2020

Was this article helpful?