Jeff Re: is output running on file?, keep file locked ?

John Esak john at valar.com
Mon Apr 18 21:17:12 PDT 2005


Mike,

I know you think you are being very explicit in your descriptions...
however, by all that you've written, the only possible answer is what Jeff
mentioned about simply putting the -u flag on your dreport command lines.
This will avoid any problems of the kind you think you might get. That is
its purpose. Using the -u flag with dreport will (U)nlock the file in that
it will not check the filePro lockfile for other users, dclerk OR dreport.
You will not see any errors about others using the file simultaneously. If
you want it spelled out any clearer than that and you feel you are not
getting good answers here, you should probably just be looking in the
manual. These things (command line options) are _very_ basic and _very_ well
described. It's not often, or EVER, that I suggest someone just R's TFM....
but... well, this is an awfully novice question to be getting upset over...
especially, when it has just been answered exactly right. As for not being
able to gain any benefit from the extra suggestion that you might do better
to just use dclerk instead of dreport... another really right-on
suggestion... it is your loss for not taking the time to understand what was
meant by the idea. He was merely saying that this, too, would behave in the
same way that putting a -u flag on your dreports would... something any one
of us would have suggested had he not done so.

John
Visit The FP Room www.tinyurl.com/yuag7 24/7

> OK,
>  Doesn't matter how many details I give, someone will always see it in a
> totally different then I write it.
>
> Forget about importing anything, forget about Inquire/Update/Add
>
> dreport,dreport,dreport
> I have one file holding all records for invoice items. Every time pick
> sheets are printed, whether from office personnel or the
> automated process,
> request output happens on this file.
> How can I be sure the automated process doesn't get the "request output
> running" error
>
> Don't get me wrong, I appreciate any feedback. Even if I can't
> benefit from
> it, I know someone took the time to write it.
>
> Thanks,
> Mike
>
>
>
> ----- Original Message -----
> From: "Jeff Harrison" <jeffaharrison at yahoo.com>
> To: "Mike Fedko" <filepro at adelphia.net>; "filePro Mailing List"
> <filepro-list at lists.celestial.com>
> Sent: Monday, April 18, 2005 10:13 PM
> Subject: Re: is output running on file?, keep file locked ?
>
>
> >
> > --- Mike Fedko <filepro at adelphia.net> wrote:
> > > windows 2000 advanced server
> > > filepro 5.0.09
> > >
> > >
> > > I have a visual basic ordering program that my
> > > customers use. The order prog has a transmit button
> > > that FTP's an order.txt file to an orders dir on my
> > > website. On my end, I have another FPT program that
> > > downloads the order.txt file to a folder called
> > > orders on my computer. I am using filepro with sleep
> > > to scan the orders dir every few seconds. If a file
> > > called "order.txt" exists, I import it into Filepro,
> > > generate an invoice, print a pick sheet, and send a
> > > confirmation back to the website. The visual basic
> > > order program will get the response if all works
> > > well.
> > >
> > > I want to make this process bulletproof, if at all
> > > possible. The biggest problem I see is, what if
> > > someone in my office is printing at the same time
> > > this automated process tries to print. The automated
> > > process is going to sit there saying "filepro error
> > > occurred, request output running on file, etc..."
> > >
> > > What I would really like to do is, as soon as I see
> > > the file in the orders dir, check if output file is
> > > locked. If it is not locked, then lock it. NOW
> > > import file in, generate invoice, unlock and print
> > > pick sheet, respond back successful.
> > >
> > > I guess the whole point is to avoid hitting the
> > > "filepro error occurred, request output running on
> > > file" I don't know the best way to do it. Has anyone
> > > done similar stuff.
> > >
> > > Any help will be greatly appreciated
> > >
> > > Thank You,
> > > Mike Fedko
> > >
> > >   > _______________________________________________
> >
> > So you are saying that you are using dreport or
> > rreport to import the file and you are worried that
> > someone will try to go into Inquire/Update/Add on this
> > file at the same time?  If that is the case you can
> > simply use the -u flag on the dreport/rreport process
> > to avoid this error.
> >
> > Alternately, you could use dclerk/rclerk with @menu
> > processing to import the file, and thereby avoid
> > request output altogether.
> >
> > Jeff Harrison
> > jeffaharrison at yahoo.com
> >
> > Author of JHExport and JHImport.  The easiest and
> > fastest way to generate code for filePro exports and
> > imports.
> >
> >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Plan great trips with Yahoo! Travel: Now over 17,000 guides!
> > http://travel.yahoo.com/p-travelguide
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list



More information about the Filepro-list mailing list