>Fabio,
>
>Do not expect this behavior to be changed. I posted a bug report on this a couple of months ago and it is working as designed.
David,
Which bug? The one in this thread where I pointed out where a UNION does not cast the data type properly?
select CAST(NumField as I) AS MyField from MyCursor where .f.
UNION ALL
select NumField from MyCursor where some_filter
into cursor crsResults
MyField in the crsResults comes out a numeric and not integer. This is hopefully NOT by design and not working as I expect.
Mark McCasland
Midlothian, TX USA