I have an application that I use to verify the latest version of an application. The following code works great "IF" I hard code the locations, I can not get it to work with it looking up the file locations in my config_info table, any ideas ?


SELECT CONFIG_INFO
updatepath = CONFIG_INFO.update_path
fileName = 'FM.exe'
Filepath = TRIM(config_info.exe_path)
FullFile = FilePath + Filename

FINDFILE = FILE(FullFile, 1)
IF FINDFILE = .T.
=AGETFILEVERSION(localversion, FullFile)
=AGETFILEVERSION(networkversion, updatepath)
LocalProduct_Version = localversion(4)
NetworkProduct_Version = networkversion(4)
IF LocalProduct_Version < NetworkProduct_Version

nAnswer = MESSAGEBOX("Update Version =" + ' ' + networkproduct_version + CHR(13) + "Current Version = " + ' ' + LocalProduct_Version + CHR(13) + CHR(13) + 'Do you want to update your version ?',4,'Product Version Info')
DO CASE
CASE nAnswer = 6
DELETE FILE &FullFile
COPY FILE &updatepath TO &FullFile
DO &FullFile
CASE nAnswer = 7
DO &FullFile
ENDCASE
ELSE
DO &FullFile
ENDIF
ELSE
DO &FullFile

ENDIF
QUIT