ODBC $ (OpenInsight 32-Bit)
At 28 NOV 2005 01:25:37PM Jim Vaughan wrote:
I have a calculated field that returns $ values.
Like $123.45
When these fields are accessed via the ODBC driver (I tested in Excel).
I get the following error:
Revelation SoftwareRevelation ODBC DriverSQLGetDataError - Error in assignment.
If I change to the calculated field to return the data without the $.
Like 123.45
The error does not appear.
Is this a bug in the ODBC driver?
At 28 NOV 2005 04:16PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
What is the datatype? Is $ valid for the datatype you have defined?
World leaders in all things RevSoft
At 28 NOV 2005 06:06PM Jim Vaughan wrote:
Data type is float.
The calculated field could return $ or Yen or etc..
What data type should I use text?
At 28 NOV 2005 10:32PM Barry Stevens wrote:
DOLLARS?
At 29 NOV 2005 11:11AM Jim Vaughan wrote:
It could also return Yen, Euros; would it still make sense to use $?
At 29 NOV 2005 03:46PM Jim Vaughan wrote:
Changing the datatype to varchar seems to have fixed the problem, thanks all.