System Command

Wed Jun 22 05:03:37 PDT 2016

Is it just something dumb maybe like you have to use "Start"...running your
command as a separate process....or does Filepro automatically send that
when you execute the system command?

Roland you said you tried many different forms of the command so I am
assuming you tried this already, But Nancy mentioned that she runs into
this problem and gets around it by writing a script and "Call"ing
it...would execute the script launch it in a separate process correct?

What if you did something like: system "cmd.exe /C "copy /y c:" { bs {
"test.txt testnew.txt > logfile"

On Wed, Jun 22, 2016 at 5:09 AM <filepro-list-request at lists.celestial.com>
wrote:

> Send Filepro-list mailing list submissions to
>         filepro-list at lists.celestial.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://mailman.celestial.com/mailman/listinfo/filepro-list
> or, via email, send a message with subject or body 'help' to
>         filepro-list-request at lists.celestial.com
>
> You can reach the person managing the list at
>         filepro-list-owner at lists.celestial.com
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Filepro-list digest..."
>
>
> Today's Topics:
>
>    1. Re: A True Puzzle (Nancy Palmquist)
>    2. Re: system command (Nancy Palmquist)
>    3. Re: system command (Kenneth Brody)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 21 Jun 2016 10:03:51 -0400
> From: Nancy Palmquist <nlp at vss3.com>
> To: filepro-list at lists.celestial.com
> Subject: Re: A True Puzzle
> Message-ID: <07694536-f71c-320f-34b7-3a9671e100d0 at vss3.com>
> Content-Type: text/plain; charset=windows-1252; format=flowed
>
> A resolution but not a solution to my puzzle.  I rebooted the server
> that was running this process and then the process worked as it should.
>
> I have no idea what difference that made since the processing would run
> in the Debug state but not without.
>
> Ken - it was not running and the proof was that the two numbers
> displayed in the middle of the screen did not change for over 5
> minutes.  If I ran it without debug on, the two numbers stated the same
> and never did anything.
> If I used the debug mode to step into the programming and ran the
> process for a number of records, when I stopped and hit CONTINUE or QUIT
> the two numbers displayed for Selected and Generated, never changed
> after that point.
>
> Break did not work to stop the process either.  Only way out was to X
> the window.
>
> I wish I could have figured out what caused it to stick, but since I got
> a resolution I have to be happy with that and say that since it has not
> happened in the +8 years the process has been in place, it is not likely
> to happen again in the near future.
>
> I expect it is some weird WINDOWS thing.
>
> Nancy
>
> On 6/20/2016 1:12 PM, Nancy Palmquist via Filepro-list wrote:
> > I have a strange puzzle.
> >
> > A process that has worked for years on a Windows platform, filepro
> > version 5.0.
> >
> > When I run it the normal way, it seems to stop before doing anything
> > at the first selected record and just sits there.
> >
> > If I add -db to the command line, the debugger starts and if I hold
> > down ENTER to step through the records with the debug it runs correctly.
> >
> > I added a SHOW on the third line so I could watch what happened when
> > DEBUG is not on and the show is never displayed when the process is
> > run normally.
> >
> > If I hit CONTINUE or QUIT in the debugger, it just hangs where ever I
> > left it in the count down.
> >
> > The command line has a -u and I double checked it is not a locked
> > record issue.  Also verified by the fact that I can step past the
> > records in the debugger.
> >
> > I rebuilt indexes - who knows right?
> >
> > Nothing has changed with regard to the data structure or programming
> > on this for many years.  It prints to a file, so it is not waiting for
> > a printer to be online.
> >
> > What am I missing?
> >
> > Nancy
> >
>
> --
> Nancy Palmquist         MOS & filePro Training Available
> Virtual Software Systems    Web Based Training and Consulting
> PHONE: (412) 835-9417           Web site:  http://www.vss3.com
>
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 21 Jun 2016 10:17:48 -0400
> From: Nancy Palmquist <nlp at vss3.com>
> To: filepro-list at lists.celestial.com
> Subject: Re: system command
> Message-ID: <54777fc6-0469-97a1-36cb-7a7570e53ffd at vss3.com>
> Content-Type: text/plain; charset=windows-1252; format=flowed
>
> Roland,
>
> I have seen this behavior and I think it is a security thing for some
> commands.
>
> First, depending on your version of Windows, you might try this syntax:
>
> system noredraw "copy /b c:"{bs{"test.txt testnew.txt"
>
> Second, some script commands just will not work in the SYSTEM command
> and when I hit one of those what I do is write a script and call the
> script.
>
> For example,
>
> script name: copyit.bat
> rem routine to copy a file
> copy /b %1 %2
>
> -----------------------------------------------------
>
> Then the system command would look like this:
> declare scriptpath, filename
> scriptpath="C:/myscripts/"
> filename=c:"{bs{"test.txt"
> scriptpath=xlate(scriptpath,"/",chr("92"))  'use this to flip slashes
> system noredraw scriptpath{"copyit.bat"<filename<"testnew.txt"
>
> I realize this could use a bit of enhancement for errors and such but
> give it a try.
>
>
> Nancy
>
> On 6/17/2016 2:05 PM, Roland Fischer via Filepro-list wrote:
> > Hi Ken
> > I am having a problem executing a system command on a Windows 7 machine
> attached to a windows 2012 network
> >
> > The command does not give me an error, but the command is not executed.
> > If I go to a dos prompt and run the command all is as it should be.
> > I have tried many different forms of the command with no resolution.
> > The system command I am trying to execute is;
> > system "copy /y c:" { bs { "test.txt testnew.txt > logfile"
> > note 'bs' field contains ascii 92 - backslash
> > Any help would be appreciated.
> > RegardsRoland Fischer
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> > URL: <
> http://mailman.celestial.com/pipermail/filepro-list/attachments/20160617/101369d0/attachment.html
> >
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > Subscribe/Unsubscribe/Subscription Changes
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> >
>
> --
> Nancy Palmquist         MOS & filePro Training Available
> Virtual Software Systems    Web Based Training and Consulting
> PHONE: (412) 835-9417           Web site:  http://www.vss3.com
>
>
>
> ------------------------------
>
> Message: 3
> Date: Tue, 21 Jun 2016 11:18:17 -0400
> From: Kenneth Brody <kenbrody at spamcop.net>
> To: nancy.palmquist at vss3.com, filepro-list at lists.celestial.com
> Cc: Nancy Palmquist <nlp at vss3.com>
> Subject: Re: system command
> Message-ID: <cf5e1ad7-2f2c-371c-7143-66fa966489f9 at spamcop.net>
> Content-Type: text/plain; charset=utf-8; format=flowed
>
> On 6/21/2016 10:17 AM, Nancy Palmquist via Filepro-list wrote:
> [...]
> > Second, some script commands just will not work in the SYSTEM command and
> > when I hit one of those what I do is write a script and call the script.
> [...]
>
> Everything "should" run via SYSTEM if it runs from the command prompt.  If
> you have any commands that don't for some reason, could you let fpsupport
> know, along with some examples showing them failing?
>
> --
> Kenneth Brody
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
> ------------------------------
>
> End of Filepro-list Digest, Vol 149, Issue 26
> *********************************************
>
-- 
Jason Garner
Systems Administrator
1801 Oberlin Rd, Suite 204
Middletown, PA 17057
Work   717-985-1122 x 1139
Mobile 717-645-3521
jason.garner at evalsvs.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20160622/0c0883c7/attachment.html>