Victor,
Sylvain


Ok it is good...

UPDATE AgendaPhar SET ;
  nconshebd = ;
  NVL( TpsMoyHebdo.nSumConsReally / TpsMoyHebdo.nDate , 0 ) ,;
  dprevision = ;
  VP_date + ;
  ICASE( AgendaPhar.nconshebd # 0.00 , FLOOR(  AgendaPhar.nstkjour / AgendaPhar.nconshebd ) , 0.00 ) ,;
  dprevisioncmd = ;
  ICASE( EMPTY(  AgendaPhar.dprevision ) ,  AgendaPhar.dprevision ,;
  MAX( AgendaPhar.dprevision - ( TpsMoyHebdo.isemcmd * 7 )  ,  VP_date ) );
  FROM  AgendaPhar ;
  LEFT JOIN TpsMoyHebdo ON TpsMoyHebdo.itraiterId = AgendaPhar.itraiterId

THank


bernhart


>12/0 isn't 0. Try IIF (x=0,0, y/x)
>
>
>>Hi all,
>>
>>
>>I want 12 / 0 give 0 .... it 's possible WITH VFP 9 ? ( How )?
>>NVL( 12 / 0 , 0 ) and EVL( 12/0 , 0 ) are'nt Good...
>>
>>Good evening
>>
>>
>>bernhart