If you run that SELECT command from the Command Window, does it work? Also, after you get the error, try running AERROR(laError) from the Command Window to see if you get an error information returned. BTW, what does (nolock) mean?
>Hi Mark
>
>I trid this but nothing change
>
>SelectCmd :
>SELECT DP.*,ST.ID_STATUT,ST.STCODE,ST.STDESCRIPTION,ST.STPAYE from A_Dependants as DP (Nolock) left join A_statut as ST (nolock) on (st.Id_statut = dp.destatus)
>
>CursorSchema
>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),ID_STATUT I,STCODE C(6),STDESCRIPTION C(30),STPAYE L
>
>
>
>>Your CursorSchema needs to include all the fields that are being SELECTED from both tables. You are selecting ST.* from the A_Statut table. Since this is probably not the only field in that table, you either have to add all the other fields to the CursorSchema or modify you SelectCmd to SELECT DP.*, ST.StCode FROM...
Mark McCasland
Midlothian, TX USA