My select - sql statement is having a bizzare behavior. If I execute the following command in my command window, 3 items are returned:

		 		 SELECT DISTINCT op_vendor ;
		 			 FROM o_ord_pay WHERE op_flag_1 = 3 ;
		 			 	AND op_flag_2 = 4 ;
		 			 		ORDER BY O_ord_pay.op_vendor

It returns 7690, AMERICAN FILING SYSTEM and MOORE which is correct.

If I issue this command in application through command button I only get one item to display AMERICAN FILING SYSTEM. I don't understand it, the data hasn't changed.


Thanks
Nick Patel