Jan, Avoid ampersand variables when doing file work Almost anyplace a filename can be used, you can use a dotted variable. The spaces get passed to the operating system correctly. This greatly simplifies file operations and avoids a lot of hacking to get things to work. Here is a demo you can try
drop table tempx CREATE TEMP TABLE TempX (Tempx Text (8)) set var vFile = 'x y' out .vFile wri 'a' wri 'b' wri 'c' out scr LOAD TEMPX from .vFile as ascii browse all from tempx return Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Thursday, December 27, 2012 8:36 AM To: RBASE-L Mailing List Subject: [RBASE-L] - enclosing quotes Group, The following sequence is causing me a challenge. --tWorkOrders SET VAR vDirectoryFileName = (.vFolderName+'\OSDoneWorkOrder.asc') SET VAR vDoLoad = ('LOAD tWorkOrder FROM '+.vDirectoryFileName+' AS ASCII') &vDoLoad This sequence works fine if vFolderName DOES NOT contain a space. I vaguely remember a discussion about this in the past but can't recall what to do. Jan
