Skip to Content
Former Member
Jul 16, 2010 at 10:36 AM

Addition of Command based Custom table removes 'Distinct' keyword in Query



I use 'Command' Object in 'Datbase Expert' to create 'Custom Tables' and use these tables to fetch LoVs. Addition of 'Command' Object is changing the existing Query and the only change is 'Distinct' in the Query got eliminated and showing 210 recirds instead of Just 10. I did not link this Custom table with any of the tables. If I delete this again the query showing only distinct values eliminating duplicates. Please help.

Edited by: Nanda Kishore B on Jul 16, 2010 12:36 PM