Hi all,

I have a remote View on paradox tables.

I want "é" letter and i have "Ú" lettre when i see the view in a browse.

 SELECT M.cMatricule AS 'cKey' ,;
    T.cNomTeleph ) ,;
  PADR( ALLTR( Ru.cnomrue ) + IIF( !EMPTY( T.cnum ),  ','   , ' '  ) + T.cnum , 40 ) ,;
  po.cpays + + ' '+ po.ccp  ,;
  po.clocalite,;
  'MUTUELLE' AS ccat;
  FROM amline!Mutuelle M INNER JOIN amline!Teleph T ON T.iid = M.itelephoneId ;
  LEFT OUTER JOIN amline!Rue Ru ON T.irueid = Ru.iid ;
  LEFT OUTER JOIN amline!Poste po ON Ru.iposteId = po.iid ;
  WHERE M.lputinpopsy = .T. INTO CURSOR tPl


compt = 1
sqlH = SQLCONNECT( 'AmlineBobConnection' )
IF sqlH < 0
  =ErrorMsg(" Impossible de se connecter à PARADOX ! ")
  RETURN .F.
ENDIF


IF  _TALLY > 0

  SELECT tPl
  SCAN ALL

    csql = [INSERT INTO COMPAN( CID, CCUSTYPE, CSUPTYPE, CNAME1, CNAME2,CADDRESS1, CZIPCODE,  CLOCALITY, CVATCAT , CCUSVNAT1, CCUSVNAT2 , CCUSCAT ) ]+;
      [ VALUES ( ?cKey ,   'C' ,  'U' ,  ?cNomTeleph, '    '  , ?adr,  ?zip,  ?clocalite , 'N' , 'XMP' , 'XMP' , ?ccat ) ]

bernhart