Dave Donovan
11th October 2004, 17:29
Hi All,
We currently have a Baan database sat on informix 7.31 ud2, we are trying to run a direct SQL query on the database via .NET.
The problem we are having is whenever we try to fetch a FLOAT or SMALLFLOAT data column it crashes the OLEDB provider. I have spoken to microsoft about this but they arn't muc help.
As a solution I would like to try and convert the data type to a decimal or even a simple text field (char. nvarchar etc.)
Not being from an informix background I don't know and can't find the syntax to cast this within a select statement.
If anyone knows this syntax or has encountered any of these problems i'd be grateful for any help.
Cheers
We currently have a Baan database sat on informix 7.31 ud2, we are trying to run a direct SQL query on the database via .NET.
The problem we are having is whenever we try to fetch a FLOAT or SMALLFLOAT data column it crashes the OLEDB provider. I have spoken to microsoft about this but they arn't muc help.
As a solution I would like to try and convert the data type to a decimal or even a simple text field (char. nvarchar etc.)
Not being from an informix background I don't know and can't find the syntax to cast this within a select statement.
If anyone knows this syntax or has encountered any of these problems i'd be grateful for any help.
Cheers