RE: [sqr-users] Can't move all files from folder

["George Jansen" <GJANSEN@aflcio.org>]

What if you were to write a batch file to execute, then remove it? If
you know exactly the files to move, you can write them in one at a time;
if not you can see what the wild card will do for you.



>>> "Karen Leary" <kleary@ubalt.edu> 11/14/2006 10:01 AM >>>
Thank you for your replies.  I am on Windows NT.  I am reading one of
the files and my program is not creating any of them.


-----Original Message-----
From: Bob Stone [mailto:bstone@fastenal.com] 
Sent: Monday, November 13, 2006 4:05 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] Can't move all files from folder

would it help to ENCODE the * character as its ASCII key?  Perhaps
something in the translation to SYSTEM code sees * as a special
character?  Could also be the \ character that thinks it means
something
else?  

Seeing as she says DOS prompt and uses MOVE instead of CP, I assume
we're in a Windows environment?  I don't do much in the way of windows
scripting, so I'm not familiar with a lot of commands.  But I would
check into whether or not there's a character in the string that
SYSTEM
would translate to do something other than just represent the
character.

While I see no CR in the code below, maybe there's a CRLF issue?

-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org 
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of
Knapp, Richard
Sent: Monday, November 13, 2006 2:00 PM
To: This list is for discussion about the SQR database
reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] Can't move all files from folder


I tried this and it will only move one file at a time and generates a
status of 1 each time.  This is a syntax error.  I tried all sorts of
variations on wildcarding but could find nothing that worked for all
the
files and nothing in the documentation that indicates a different
syntax
except leaving the final slash off but even that doesn't affect the
desired movement.

Richard Knapp
AITS - Reporting
University of Missouri
Locust Street Building
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu 

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org 
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Bob Stone
Sent: Monday, November 13, 2006 1:09 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] Can't move all files from folder

are they files that your program created?  And if so, are they closed?
You can't move a file you're still writing to because the system shows
SQRUSER as having control of a open file.

Also note that you can't move the log file or the .lis file
automatically created, because those aren't closed until the program
finishes.  Maybe there's actually a way to do that, but if I've had to
do something where I want to delete the file (or move it, in your
case)
then I always open a file for writing and close it before I have to do
anything with it.

What system is this on?  



-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org 
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of
Karen Leary
Sent: Monday, November 13, 2006 12:54 PM
To: sqr-users@sqrug.org 
Subject: [sqr-users] Can't move all files from folder

I am trying to move some files from one folder to another when
finished
processing.

I am using the following syntax which only moves one of the files
instead of all of them - any ideas why???


Let $move = getenv('COMSPEC') || ' /C move ' || $ArchivePath || '*.* '
|| $ArchivePath || 'archive\'

call system using $move #status wait


Each time I run the program it will move one file.  If I run the same
command from a dos prompt it does move all the files.



Thank you,
Karen






_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users