I dunno if jBase is the same as D3 in this regard but when using the DBMS Copy 
verb I think the data is pulled into the DBMS first before it's written back to 
the OS. That's going to be Very slow. It would be better to use the DBMS to 
script command-line operations. You can write a large script and execute it all 
once. You can do an Execute "!Copy..." of individual files. Or you can create a 
huge OS command and then do a single Execute.

And I could be completely off... :)

As to paths with spaces in them, I wrote a utility a while back which retrieves 
the short-directory name using the Windows DIR command. Then I used that in my 
commands to eliminate grief from spaces. I don't think that's necessary here 
but if you need to do that it's possible.


HTH

T



On Monday, July 28, 2014 1:18 PM, Charlie Noah wrote:
 


I have several thousand image files I want to copy from various Windows folders 
(a couple hundred) to one Windows folder. My plan was to cheat and build a 
paragraph to copy the image files. The problem comes when the source folder 
name has spaces in it. It seems COPY doesn't like them, and truncates the file 
name (actually the folder name) at the first space.

Example:
COPY "e:\TinyBearMarketing\GOLDCREST\Images\Purple Martin Decoys
    & Starling Excluder Doors\" PME2.jpg
results in:
** Error [ 201 ] **
Unable to open file "e:\TinyBearMarketing\GOLDCREST\Images\Purple

I've tried with and without quotes, so that isn't it. Has anyone
    found a way to overcome this, or a better way to do it? The reason
    I'm using COPY (well, actually COPYTO, a one-line COPY frontend)
    because I can build the COPY statements in a list driven JQL report.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to