PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEVWEBDEV and WINDEV Mobile

Home → WINDEV Mobile 2024 → Filtering a database for a multiline zone
Filtering a database for a multiline zone
Started by Ben, Jan., 09 2017 10:39 PM - 1 reply
Posted on January, 09 2017 - 10:39 PM
Hi, currently I am building an app for event logging. I have a page where on the left you select an event and its details are displayed. Part of this is a list of attending people, Currently I am using the following code but it doesn't seem to be filtering correctly. What am i doing wrong?

HReadSeekFirst(Client_RoadShow,RoadShowID,Form)

WHILE HFound()
HReadSeekFirst(Client,ClientID,Client_RoadShow.ClientID)
nLine is int = mlzAddLine(MZ_Clients)
MZ_Clients[nLine].STC_Title = Client.Name
MZ_Clients[nLine].STC_Business = Client.Business
HReadNext(Client_RoadShow)
END
Posted on January, 10 2017 - 1:14 PM
Hi Ben

it looks like you are missing the key in the hreadnext (it needs to be
the same key than in the hreaseekfirst, so that the compilers knows the
two are linked)

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

Ready for you: WXShowroom.com, WXReplication (open source) and now WXEDM
(open source)

More information on http://www.fabriceharari.com


Le 1/9/2017 à 4:39 PM, Ben a écrit :
Hi, currently I am building an app for event logging. I have a page
where on the left you select an event and its details are displayed.
Part of this is a list of attending people, Currently I am using the
following code but it doesn't seem to be filtering correctly. What am i
doing wrong?

HReadSeekFirst(Client_RoadShow,RoadShowID,Form)

WHILE HFound() HReadSeekFirst(Client,ClientID,Client_RoadShow.ClientID)
nLine is int = mlzAddLine(MZ_Clients)
MZ_Clients[nLine].STC_Title = Client.Name
MZ_Clients[nLine].STC_Business = Client.Business
HReadNext(Client_RoadShow)
END