Check Duplicate Data Using Fillter DataWindow/DataStore In PowerBuilder
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | //now use this sort and filter to leave only duplicate rows lds_buffer.SetSort ("user_id A") lds_buffer.Sort() lds_buffer.SetFilter ("user_id = user_id[-1]") lds_buffer.Filter() If lds_buffer.RowCount() > 0 Then //got a dup, tell the user which one! al_row = lds_buffer.GetItemNumber (1, "row_num") as_colname = "user_id" as_error = "Duplicate User ID." Return -4 End If //no dups, so clear the filter and do the update... lds_buffer.SetFilter ("") lds_buffer.Filter() |
Good Luck!
Users Today : 70
Users Yesterday : 69
This Month : 846
This Year : 846
Total Users : 220940
Views Today : 196
Total views : 915742
Who's Online : 1