08/03/2016 14:52:56: Error: SQL##f - SqlState: S0002, ErrorCode: 4294965991, ErrorMsg: [Microsoft][ODBC dBASE Driver] The Microsoft Access database engine could not find the object '2016 01 01 0000 [Wide].DBF'. Make sure the object exists and that you spell its name and the path name correctly. If '2016 01 01 0000 [Wide].DBF' is not a local object, check your network connection or contact the server administrator.
08/03/2016 14:52:56: 0098 DISCONNECT
08/03/2016 14:52:56: 0099 NEXT file
it says that the file doesnt exist but when looking in the folder i can see the file. what i have noticed is that on line 0091 the file is loaded in and the file itself is 2016 01 01 0000 (Wide).DBF but the error message has the file name as 2016 01 01 0000 [Wide].DBF - it has square brackets, so i assume this is the problem. i just dont understand why its correct when loaded in (0091) but incorrect in the error.
can anyone help?
my script is.
LET Data = chr(96) & '$(vDirectory)' & chr(96) & '\' & chr(96) & Subfield(GetShortName('$(file)'),'\',-1) & chr(96);
i wondered this also ( i didnt create this script).
i tried removing them but still get an error.
Error: SQL##f - SqlState: 37000, ErrorCode: 4294966294, ErrorMsg: [Microsoft][ODBC dBASE Driver] '..\..\..\VeoliaData\SCADA Data\MacDuff\DLGLOG\bankhead ps\2016 01 01 0000 [Wide].DBF' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.
again, the fielname contains [Wide] where it should be (Wide) but im unsure if this is relevant.
well as the link i gave earlier says the maximum file name size cant be more than 8 characters i assumed the actual file name would be shortened but it doesnt look like GetShortName is doing anything as the file name is the same!
i do get a different error though when trying to use FROM $(file).
i dont understand why the brackets change to the square brackets though in the error message