[RBASE-L] - RE: Gateway syntax

[Dawn Hast]

Bob,

 

I think you need to enclose the file name in quotes if it has spaces.

 

Dawn

-------------- Original message from ttc....@comcast.net: --------------

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" <bu...@medschool.pitt.edu>
To: "RBASE-L Mailing List" <rbase-l@rbase.com>
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: rbase-l@rbase.com [mailto:rbas...@rbase.com] On Behalf Of ttc....@comcast.net
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