I have a an action button with the formula below. Before going to R6, no problems. After R6 I receive the error, “File does not exist: coaster.gif”. I have tried .bmp, .tif, .jpg, etc. Is it R6 or is it something else? I cannot figure this out, I hope someone can help, thanks.>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
FileName:=@Prompt([LocalBrowse] ; “Select File to Attach” ; 1);
@If(FileName=“”; @Return(“”); @Success);
@SetField(“FileName” ; @RightBack(FileName; “\”));
FileExt:=@UpperCase(@Right(FileName; “.”));
FileType:=@If(FileExt=“JPG”; “JPEG Image”; FileExt=“GIF”; “GIF Image” ; FileExt+" Image");
@Command([EditGotoField];“attachment”) ;
@Command([EditInsertFileAttachment]; FileName ; “0”);
@Command([EditGotoField];“display”) ;
@Command([FileImport]; FileType ; FileName)
Subject: Problem is the @Formula code does not know wether you mean the…
Field FileName, or the Local Variable FileName. Try:
FName:=@Prompt([LocalBrowse] ; “Select File to Attach” ; 1);
@If(FName=“”; @Return(“”); @Success);
@SetField(“FileName” ; @RightBack(FName; “\”));
FileExt:=@UpperCase(@Right(FName; “.”));
FileType:=@If(FileExt=“JPG”; “JPEG Image”; FileExt=“GIF”; “GIF Image” ; FileExt+" Image");
@Command([EditGotoField];“attachment”) ;
@Command([EditInsertFileAttachment]; FName ; “0”);
@Command([EditGotoField];“display”) ;
@Command([FileImport]; FileType ; FName)
Subject: RE: Problem is the @Formula code does not know wether you mean the…
Thank you so much Bill. That fixed the problem. Odd though, that it had worked for over a year, but we did just upgrade the server and clients. Oh well, it works and that’s the important thing! Thanks again!
Subject: There is a new Formula Engine in R6.
Apparently the old 1 used the First reference to the name through out the formula, but the New one references the last used.