KPonn wrote:
>
> Hi
>
> I am trying to fetch a Decimal(16,4) field into Some_variable with Indicator. I
> am getting error -1223
>
> Ex: Fetch sel_cur into :x indicator :y
>
> In C, what type should x (double, float, int etc ????) be ? Can I use
> Indicator variables for decimal fields ?
>
> Thanks for your help.
See the manual, it tells you to EXEC SQL include decimal; and then use
the type dec_t to create a decimal type. If you really want a C type,
use double. The error is telling you the value will not fit in a C
float.
--
Peter Lancashire
Information Systems Specialist, Bayer plc
Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK
Tel: +44-1635-562258, Fax: +44-1635-562281
Mail: Peter.Lancashire.PL1@bayer.co.uk
---
My Internet plumbing does not allow me to mail and post news together.
Sorry.
All opinions are my own and not those of Bayer plc.
---
Join Infuse, the UK Informix User Group at http://www.infuse.co.uk/