Distinct workaround..

This topic is locked

Distinct workaround..	4/15/2009 9:00:35 AM
PHPRunner General questions
M michaelmac author Hey Everyone Hope all is well in your world. I am trying to find a workaround to the "distinct" keyword in PHPR/ASPR. I need to use it from time to time, and unless it is working with the 5.x version of PHPR or 6.x ASPR, I can not make it work. Anyone suggest a way they did it? Thanks Mike


W	wilri01 4/27/2009
	Hey Everyone Hope all is well in your world. I am trying to find a workaround to the "distinct" keyword in PHPR/ASPR. I need to use it from time to time, and unless it is working with the 5.x version of PHPR or 6.x ASPR, I can not make it work. Anyone suggest a way they did it? Thanks Mike If you are wanting to use DISTINCT as a column name and not as a keyword, use double quotes: select "distinct", col2 From.... will treat distinct as a column name. It's called a delimited SQL identifier.