Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cast() is evaluated for every record
Message
 
 
To
09/09/2004 14:32:36
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Beta
Miscellaneous
Thread ID:
00940524
Message ID:
00940769
Views:
19
Fabio,

It's documented UNION behavior not a bug. From the help, "When two columns of different data types are involved in a UNION operation, the data type with the lower precedence is converted to the data type with the higher precedence".
In regard to not submiting bugs to MS, it's just childish behavior on your part.

>Sure,
>but you known that i want do not post
>other bugs until retail VFP9 exit.
>
>
>CLEAR
>SET TALK OFF
>
>DIMENSION xTypes[3]
>xTypes[1]='N(3,0)'
>xTypes[2]='B(0)'
>xTypes[3]='Y'
>
>FOR EACH xType in xTypes
>	CREATE CURSOR myCursor ( f1 &xType)
>
>	? 'type', m.xType
>	
>	SELECT CAST(F1 AS I NULL) F2 INTO CURSOR R1 FROM myCursor
>
>	? aInfo[AFIELDS(ainfo),2]
>
>	SELECT CAST(F1 AS I NULL) F2 INTO CURSOR R2 FROM myCursor WHERE .F.;
>	UNION ALL ;
>	SELECT F1 FROM myCursor
>
>	? aInfo[AFIELDS(ainfo),2]
>NEXT
>
>
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform