>hi all,
>i try to add path at the field via this code,
>this code rename all as .doc,if i change .doc to tif it take all as tif
>the folder ta3ameem2010 have tif,.doc,.pdf.bitmap immage,jpeg....etc
>i need to replace the extention as it is
>thanks
>
>

> replace mycur12005.clint with iif(file("d:\ta3ameem2010\" +alltr(mycur12005.fielda )+".tif"),"d:\ta3ameem2010\" +alltr(mycur12005.fielda )+".DPF","d:\ta3ameem2010\" +alltr(mycur12005.fielda )+".doc") ALL in mycur12005
>
>

>
>
>thanks

Hi,
you could do this like this:

CREATE CURSOR mycur12005(clint c(50),fielda c(20))
INSERT INTO mycur12005(clint, fielda) VALUES ([],[datei1])
INSERT INTO mycur12005(clint, fielda) VALUES ([],[datei2])
INSERT INTO mycur12005(clint, fielda) VALUES ([],[datei3])
INSERT INTO mycur12005(clint, fielda) VALUES ([],[datei4])
INSERT INTO mycur12005(clint, fielda) VALUES ([],[datei5])

lcDir = [d:\ta3ameem2010\]

REPLACE ALL clint ;
WITH ;
IIF( ;
	FILE( FORCEEXT( lcDir + ALLTRIM( fielda ) , [.tif] ) ) , ;
	FORCEEXT( lcDir + ALLTRIM( fielda ) , [.dpf] ) , ;
	FORCEEXT( lcDir + ALLTRIM( fielda ) , [.doc] ) ;
	) ;
	IN mycur12005

BROWSE LAST 

USE IN SELECT( [mycur12005] )