With ALLTRIM() some records can be cut to the LEN() of the first record i.e. If the first record LEN(ALLTRIM( ve.gcommentfamille )) = 10 the field will be defined as Char(10) and all of the rest records will be cut to Char(10)
In VFP 9 You can use:
CAST(ALLTRIM( ve.gcommentfamille ) AS V(254)) AS 'memoFam';
Then you can get a Varchar field not memo with 254 chars length.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.