Make sure there is a SPACE beteen On and (St.Id_Statut = Dp.DeStatus). The Invalid function is interpreting On(St.Id_Statut = Dp.DeStatus) without the space as a function.
>(Nolock) is for keeping sql from locking table
>My CA use sql table, I've suppose that my select must be a sql select
>Is it true.
>
>I have change my SelectCmd for this
>Select Dp.*,St.STCODE From A_Dependants As Dp Left join A_Statut As St On(St.Id_Statut = Dp.DeStatus)
>
>and my cursorschema for this
>ID_DEPENDANTS I,ID_MEMBRES I,DENOM C(20),DEPRENOM C(20),DENATURE N(3,0),DEDATENAISSANCE D,DATEDEBUT D,DATEFIN D,DEREMARQUE M,DESTATUS I,DESEXE N(3,0),STCODE C(6)
>
>As the first time if lusecursorschema = .f. it'work but if it = .T.
>it dosent.
>Aerror() Return this
>(1,1) 2005
>(1,2) "00000001" Incorrect function
>(1,3) "00000001" Incorrect function
Mark McCasland
Midlothian, TX USA