there is checkbox for show all records and formfunctionbuttoncontrol apply button.
if i check the show all records and click apply. duplicate data is shown. e.g
Name age From to
a 1 1/1/1990 1/1/2000
b 2 1/2/1990 1/2/2000
c 3 1/3/1990 1/3/2000
a 1 1/1/1990 1/1/2000
b 2 1/2/1990 1/2/2000
c 3 1/3/1990 1/3/2000
but after i click apply button again. it displays the correct info.
Name age From to
a 1 1/1/1990 1/1/2000
b 2 1/2/1990 1/2/2000
c 3 1/3/1990 1/3/2000
what do you think is the problem? and how to resolved this? thanks.
someone told me i should change the datasource to null? on runtime? how to do this?
First of all, review the queries and compare the differences, it will likely tell you what’s wrong. Try refreshing the data source - maybe that’s the only missing part.
If the problem is in your code and you fail to identify it, you’ll have to show us the code. We have currently no idea what code you execute when clicking the button.
Thanks. I’ve resolved this by changing the JoinSource Property to InnerJoin. It was on outer join. It runs the same code and I was told that
The form displays duplicate records because the ‘HCMWorker’ buffer table stores the selected worker twice. Clear first the ‘HCMWorker’ buffer table before re-initiating the query when you click Apply button.
But I don’t know how to do this since its passing and running on different methods. And I’m still a newbie. =)
If you can think of another solution. I would still appreciate it. As I’m not sure if what I do was right and if it may not affect the system in the near future. I just read it online that the research method works with inner join well.
I don’t understand what you’re saying. Why the ‘HCMWorker’ buffer table stores the selected worker twice? Which methods are you talking about in “its passing and running on different methods”?