General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I have put a space and now I got this:
Error loading file number 7. GrdvDep or one of its members. ControlSource: alias Vdep is not found
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only