>IN Fact the problem become from a another code
>I try to build per programmation a complex sql command
>
>TEXT To oSql.cSql NOSHOW TEXTMERGE PRETEXT 15
> << m.cSql1 >>
> << m.cInner1 >>
> << oSql.ccondit1 >>
> << m.cSql2 >>
> << m.cInner2 >>
> << oSql.ccondit2 >>
> ORDER BY 3 , 1, 4 , 2 INTO CURSOR CrystalNew READWRITE
> ENDTEXT
>
>
>&oSql.cSql Give :
>
>
>SELECT T.cnomteleph AS 'cNomRes' , D.nFacT, M.cmatricule, ...
>
>
>
>A error 16 "unrecognised command"...
>
>
>Do you see something bad ?
Won't the "m.", used as alias name, be confused with a memory variable? Try using some other alias. Other single-letter aliases might also cause confusion, because of special meanings they have.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)