Pushkey "[SAVE]" question

Nancy Palmquist nlp at vss3.com
Wed Oct 10 10:02:50 PDT 2007


Don Coleman wrote:
> Discovered a record lock issue this AM caused by my processing.  
> Windows 2000 & XP clients, Windows 2000 Advanced Server fP v5.0.13.  fP is
> installed on the server and accessed via *.bat file from the client via a
> mapped drive.  Contents of the *.bat file are:
> 
> ECHO OFF
> TITLE=filePro Rx WORKFLOW APPLICATION (LASER PRINTER)
> SET PFNET=ON
> SET FILES=60
> SET PFFILES=80
> SET PFTMP=C:\TEMP
> SET PFDSK=E
> SET PFDATA=E:
> SET PFPROG=E:\FP_SETUP_FILES\FP5.0.13
> SET PFDIR=\QS1\TODO
> SET PFCONFIG=E:\FP_SETUP_FILES\FP5.0.13\CONFIGURATION\LASER
> SET PATH=C:\PRINTWIZ
> SET PFSHOWWINERROR=ON
> %PFPROG%\FP\P.EXE SCRIPT
> 
> When the user uses an @KEY function (@KEYR) in an input process table while
> sitting on the record the record remains locked after the @KEY logic ends.
> In several tests so far sometimes the record is released when the user exits
> fP, sometimes not.  They are currently testing to see if the record lock is
> always released if the client is rebooted.
> 
> Each occurrence of pushkey "[SAVE]" previously was followed by an "end"
> statement.  As a result of this reproducible problem I modified the logic to
> be 
> Pushkey "[SAVE]";write;close;goto @ENTSEL (the @ENTSEL is to redraw some
> dummy variable display information.  
> 
> Is using pushkey "[SAVE]" within @KEY logic causing my record lock, and if
> so, what is a better option?  I would have expected the "write;close" to
> resolve the issue (with admittedly more system overhead) but it did not.
> Come to think of it, I probably don't need the write if I do need the close.
> I believe Ken B. has stated previously that the close includes a write
> automatically.
> 
> Any suggestions.  The @KEY processing is used to move an order "back" in the
> fulfillment process.
>  
> 
> Oct 10, 2007  11:42           File Name: QS1                       Page   1
>                              Processing: test_input
> 
>  111 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
> @KEYR    If: CB eq "2"
>        Then:
> 53="";AC="";57="";AD="";61="";AE="";65="";AF="";50="N"{9;144="";145
>              ="";146=""
>  112 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>          If: CB eq "2"
>        Then:
> 49="1";54="";55="";56="";58="";59="";60="";62="";63="";64="";66="";
>              67="";68=""
>  113 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>          If: CB eq "2"
>        Then:
> 69="";85="";AG="";70="";71="";DF="";DP="";DV="";EU="";display;pushk
>              ey "[SAVE]";write;close;goto @ENTSEL
>  114 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>          If: CB eq "3"
>        Then:
> 57="";AD="";61="";AE="";60="";64="";58="";62="";59="";63="";65="";A
>              F="";49="2";50="N"{9
>  115 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>          If: CB eq "3"
>        Then: 66="";67="";68=""
>  116 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>          If: CB eq "3"
>        Then:
> 69="";85="";AG="";70="";71="";DF="";DP="";DV="";EU="";display;pushk
>              ey "[SAVE]";write;close;goto @ENTSEL
>  117 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>          If: CB eq "4"
>        Then:
> 49="2";61="";AE="";64="";63="";62="";65="";AF="";68="";66="";67="";
>              69="";50="N"{9
>  118 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>          If: CB eq "4"
>        Then:
> 69="";85="";AG="";70="";71="";DF="";DP="";DV="";EU="";display;pushk
>              ey "[SAVE]";write;close;goto @ENTSEL
>  119 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>          If: CB eq "5"
>        Then: 49="4";65="";AF="";68="";66="";67="";50="N"{9
>  120 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>          If: CB eq "5"
>        Then:
> 69="";85="";AG="";70="";71="";DF="";DP="";DV="";EU="";display;pushk
>              ey "[SAVE]";write;close;goto @ENTSEL
>  121 -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
>          If: 
>        Then: pushkey "[SAVE]";write;close;goto @ENTSEL
> 

How about ESCAPE command?  An @key routine does lock the record.  You 
need to END it to unlock and you are doing a GOTO and running something 
else.  I am not sure what is in the @entsel but it will run when the 
@key is finished anyway.

Try it with the debug on and you will see.

Nancy


> 
> Don Coleman
> Donald G. Coleman, Consultant
> 402 Andrew Circle
> Indiana, PA 15701
> dcoleman at dgcreact.com
> (724) 349-6302
> 
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> 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


More information about the Filepro-list mailing list