Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cast() is evaluated for every record
Message
 
 
À
09/09/2004 14:32:36
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro Beta
Divers
Thread ID:
00940524
Message ID:
00940769
Vues:
18
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform