Hello,
I'm using the WCF-SQL adapter to select specific columns in a table.
It works fine in my test environment, but when it runs in Production, here is the error message I got
The columns aaaaa and bbbbb are either duplicated or not in a sequence. Each column can only be selected one time, and columns must be selected in sequence.
It appears that the columns in the table in Production are not in the same order as in Test.
Before asking my client to drop and and recreate this table (and eventually others), I was wondering if there is something I could do to have my query to work in both environments?
Thank you