Recent content by indyrk

No luck with that! Thanks for your help though, I appreciate it. -Rob

One thing about this query, the rounding only seems to happen inside the CASE statement. So if the query is: Select tmcomcred, baamount, baamount-tmcomcred, case when tmcomcred>0.00 then baamount-tmcomcred else 0.00 end from table the first subtraction gives a decimal result, the second...

Thanks, Yes, I have tried wrapping the subtraction statement in a cast function, no change. The DB is Progress v9. -Rob

Hi, I have a query where I am subtracting two numbers, and the result is always rounded, but I need it not to do that. The two data fields are defined in the database as numeric(17). My query looks like this: select tmccomcred, baamount, case when tmcomcred<>0 then baamount - tmcomcred else...

Hello, I am trying to connect to a Progress database using the DataDirect 4.10 32 Bit Progress SQL92 v9.1E ODBC driver. I am getting an error: [datadirect][odbc progress driver]invalid attribute in connection string: description.[datadirect][odbc progress driver][progress]-219901 The...