SELECT DISTINCT statement error

Archived Topics
1

I have almost completed the large task of converting from MySQL to MSSQL and have a few issues left one of which is the folllowing. I am attempting to fill a dataset in FPMI using the following code:

SELECT DISTINCT ShiftID FROM table ORDER by ShiftID ASC

I am getting an error that states that:

Any ideas? The 'ShiftID' column is type string. The values are A,B,C,D,etc.... In this table, the values appear many times, and I only want to have one of each the dataset is used for selector.

thanks yet again.

2

Your ShiftID column should not be a TEXT datatype (that datatype is for really long strings). It should be a VARCHAR or better yet, if they are all one character, a CHAR(1) column.

3

Ok. I will try that.

Thanks