Mark,
It's not a bug. See me response to Fabio.
>>
>>Can you post code that reporo the bug?
>
>create cursor MyCursor (F1 N(6,0))
>
>insert into MyCursor values (100)
>
>*!* returns a numeric column instead of Integer
>select cast(F1 as I) where .f. FROM MyCursor ;
>union ALL ;
>select F1 from MyCursor ;
>into cursor crsResults
>DISPLAY STRUCTURE
>
>*!* following works as expected
>select cast(F1 as I) where .f. FROM MyCursor INTO CURSOR crsResults2
>DISPLAY STRUCTURE
--sb--