Yes the filename contains spaces.
R>sho var vfilename M:\MRP\Item Sales Review.xls Using the & instead of the . pops up an error stating "Select import mode!" I have replaced the variable with the actual path in quotes 'M:\MRP\Item Sales Review.xls' and the system locks up as before. I renamed the file so no spaces where included. I changed all references to the file name accordingly. Still locks up when issued at R:> but runs OK in Gateway menu with same specification file loaded. The task manager shows no CPU usage, it just hangs with the hour glass and I have to kill the process. ??? Thanks -Bob ----- Original Message ----- From: "Buddy Walker" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, July 15, 2009 10:15:20 AM GMT -06:00 US/Canada Central Subject: [RBASE-L] - RE: Gateway syntax Bob Try using &vfilename instead of .vfilename. Does the path/filename contain spaces. Buddy From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, July 15, 2009 9:15 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Gateway syntax Does anyone see an error in the below syntax? When I execute it, Rbase locks up and I have to kill the process to get out. However, if I run GATEWAY via the menu, load the specification file MRPINFO.rgw and execute, it works fine. --Load data into tmpitem from excel spread sheet set var vFileName text = 'M:\MRP\Item Sales Review.xls' GATEWAY IMPORT XLS .vFilename APPEND TmpItem + OPTION specification_file_name MRPINFO.rgw|+ SHEET_INDEX 1 Thanks all, -Bob
