>Preface:
>If i apply a CAST sequence: CAST(CAST(CAST(...CAST(
>and all the intermediate CAST are
>
F - given Full conversion without loss of >I aspected that the result is the same one of that one obtained making a cast directed only one.
>
>VFP not respect this invariance rule.
Same as before. When Fox does its implicit data conversion on an append, it doesn't do this conversion, so CAST() won't operate differently.
CREATE TABLE date1 (tField datetime)
INSERT INTO date1 VALUES (DATETIME())
BROWSE
CREATE TABLE date2 (tField c(20))
APPEND FROM date1
BROWSE
CREATE TABLE date3 (tField date)
APPEND FROM date2
BROWSE