DeDuplicate On Column colkey With DataWindow In PowerBuilder
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | // check duplicate ON column colkey datatstore ds_colcheck ds_colcheck = Create datastore ds_colcheck.DataObject = "d_checkcolumn" ds_colcheck.Retrieve() ds_colcheck.SetSort( "colkey A") ds_colcheck.Sort() //THEN you can deduplicate USING THIS filter : //THIS can avoid a LOOP FOR flagging rows TO be filtered. //We use THIS technique TO deduplicate OR TO get distinct values FROM a datastore/datawindow. ds_colcheck.SetFilter( "getrow()=1 or colkey <> colkey[-1]") ds_colcheck.Filter() |
Good Luck!
Users Today : 154
Users Yesterday : 80
This Month : 3276
This Year : 24782
Total Users : 210235
Views Today : 443
Total views : 876638
Who's Online : 1