WWW.Amline.Be\UT6.jpg


>Would completely bracketing the logical expressions help? e.g.
>
>lrepondant = (( NVL( repondant.itelephoneid, 0 ) ) > 0) ;
>
>
>>thank jim but now i have a error 1845 SQL expression is too complex.
>>
>>
>>
>>
>>>Remove the commas before each word "LEFT" (at ends of previous lines).
>>>
>>>
>>>>File 'left.dbf' does not exist.
>>>>
>>>>
>>>>
>>>>>What is the error message, or the unexpected behaviour?
>>>>>
>>>>>>Hi all,
>>>>>>
>>>>>>What is bad in my command ?
>>>>>>
>>>>>>

>>>>>>*-- Remplacer lrepondant ds teleph.dbf si correspondance
>>>>>>*-- de la clé primaire teleph.iid ds repondant.dbf ( itelephoneid )
>>>>>>UPDATE v_Teleph ;
>>>>>>  SET ;
>>>>>>  lrepondant 	= ( NVL( repondant.itelephoneid, 0 ) ) > 0,;
>>>>>>  lpersonnel 	= ( NVL( Employee.itelephoneid , 0 ) ) > 0,;
>>>>>>  lresident 	= ( NVL( Resident.itelephoneid , 0 ) ) > 0,;
>>>>>>  lmedecin 		= ( NVL( medecin.itelephoneid  , 0 ) ) > 0,;
>>>>>>  lmutuelle 	= ( NVL( Mutuelle.itelephoneid , 0 ) ) > 0;
>>>>>>  FROM V_Teleph ;
>>>>>>  LEFT OUTER JOIN repondant 	ON v_Teleph.iid = repondant.itelephoneid,;
>>>>>>  LEFT OUTER JOIN Employee 	ON v_Teleph.iid = Employee.itelephoneid,;
>>>>>>  LEFT OUTER JOIN Resident 	ON v_Teleph.iid = Resident.itelephoneid,;
>>>>>>  LEFT OUTER JOIN medecin 		ON v_Teleph.iid = medecin.itelephoneid,;
>>>>>>  LEFT OUTER JOIN Mutuelle 	ON v_Teleph.iid = Mutuelle.itelephoneid
>>>>>>

>>>>>>
>>>>>>
>>>>>>bernhart