In a grid, I have an SQL statement that includes the DISTINCT word. In debug mode, I can see that the SELECT COUNT(*) correctly includes the DISTINCT so the count comes out correct at (in my case) 45. However, the second SQL displayed, the one the grid is populated with, does NOT include the DISTNCT.. so I'm getting repeat rows in the grid and the number of records is of course too high (> 45).
No announcement yet.
[SOLVED]Grid SQL is not inlcuding the DISTINCT word