[WM24] How to display non-repeatable data

Hello guys,i'm new for using Windev Mobile now I must work to continue the project but i still new in here....
so i have a problem with looper display
.I have a search bar which functions to search for names, when double-clicked
from the database that should appear is 2 data show but the fact that the data that appears is more than 2 data and the data is repeating, what should I do so that the same data does not repeat?

this is my code in the search bar
sm_QryParamedic.Paramsm_paramedicName = FindBar
LooperDisplay(Looper_Doctor,taReExecuteQuery)

and this is the code in looper

HReadSeek(paramedic,paramedicID,QryParamedic.paramedicID)
HReadSeek(paramediclocation,paramediclocationID,QryParamedic.paramediclocationID)
HReadSeek(workinghour,workinghourID,QryParamedic.workinghourID)
OpenMobileWindow(MenuProductAppointment)

Thanks



Edited 1 time(s). Last edit at 05/06/2020 06:48AM by Xon_Jack.

I don't know the structure of your DB but if i understand your problem correctly it looks like the problem is in the query.
If you don't want duplicate values just use DISTINCT if the query

Regards

Paulo Oliveira