RDS "Duplicate output destination" Error



I have RDS working, and working well, using Access 97 as the data source.



I recently wanted to include formatted currency fields so I changed my 

SELECT clause from something like



"SELECT this_value, Other_Fields from MyTable"



To 



"SELECT this_value, Format(this_value,"###,###,##0") as 

Formatted_This_value, Other_Fields from MyTable"



I included the unformatted field as well since I wanted to use this as a 

separate column within RDS so that I could use the sort feature. (Sorting 

on a formatted currency field is the same as sorting on a string and does 

not provide the correct order).



With RDS/MDAC 1.5 on the server it worked well, however when I upgraded 

the server to MDAC/RDS 2.5, and tried to save updated client records to 

the server via the 'SubmitChanges" method,  it started giving me 

a ""Duplicate output destination"  error.



I assume this is because the UPDATE or INSERT SQL statement generated by 

RDS tries to update the "this_value" field twice.



My questions are:



1. Is this assumption correct?

2. Is there any other way to format a currency, or in fact a date field 

within RDS itself so that I don't have to include the field twice in my 

SELECT statement?

3. Is there any way around this problem?



Steve Helbig

Australia