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
__________________
Regards

Dave Donovan
:o

I believe casting was introduced in version 9.

select cust_nbr::char(1) from customer;

Sorry not much help.

Andy

HI...
This may seem like a stupid solution...but u may try creating a temp table with decima / text fields corresponding to the float fields in ur table. Then load the temp table and try fetching it. (seems like a roudabout way of doing things - but may just work) ;)