INPUT FROM "VARIABLE" WAS NOT FOUND (293)

Posted by ridingmac on 25-Oct-2018 12:46

i get an wp-load-file was not found(293) error when executing this code. wp-load-file is used in a SYSTEM-DIALOG and return the full path for the file including file name. I have confirmed this with an ALERT-BOX

INPUT FROM wp-load-file CONVERT TARGET "UTF-8" SOURCE "UTF-8" NO-ECHO.
REPEAT:
CREATE PARAM_tt_nice_convention.
IMPORT DELIMITER ",":U PARAM_tt_nice_convention.
END.
INPUT CLOSE.

How ever if i replace wp-load-file with a hardcoded string pointing to the exact same path, it works files.

INPUT FROM "C:\temp\excelFile.csv" CONVERT TARGET "UTF-8" SOURCE "UTF-8" NO-ECHO.
REPEAT:
CREATE PARAM_tt_nice_convention.
IMPORT DELIMITER ",":U PARAM_tt_nice_convention.
END.
INPUT CLOSE.

I have confirmed that wp-load-file give tha exact same path.

Thanks in advance for the help.

OpenEdge Development - Forum

Posted by Matt Gilarde on 25-Oct-2018 14:18

Try INPUT FROM VALUE(wp-load-file). Without VALUE it tries to open a file named wp-load-file instead of the value of the variable.