call "fpimport" (file is always locked) SYSTEM

[John Esak]

Just a complete guess... but it is possible that a generic CLOSE will only
close "lookup" file handles.  Why not try a specific CLOSE for the txt file
itself  "CLOSE textifle_or_alisa".  It may work. Ken can, of course, verify
this, but you could try it before he responds to this suggestion.

John Esak





> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com
> [mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of Mike Fedko
> Sent: Wednesday, April 13, 2005 4:07 PM
> To: filePro Mailing List
> Subject: Re: call "fpimport" (file is always locked) SYSTEM
>
>
> SYSTEM
> windows 2000 Advanced Server
> Filepro 5.0.09
>
> I have a CLOSE;EXIT at the end of the process that I call to import the
> data.
>
> Mike
>
> ----- Original Message -----
> From: "Fairlight" <fairlite at fairlite.com>
> To: "filePro Mailing List" <filepro-list at lists.celestial.com>
> Sent: Saturday, April 16, 2005 3:06 PM
> Subject: Re: call "fpimport" (file is always locked)
>
>
> > At Wed, Apr 13, 2005 at 02:51:05PM -0400 or thereabouts, suspect Mike
> Fedko
> > was observed uttering:
> > > I am running a process using the SLEEP along with EXISTS
> commands to see
> > > if there is a file to be imported. If the file exists, I use
> CALL to run
> > > the import process. At the end of the actual import processing, I try
> > > to delete the .txt document, that was imported. At this
> point, the .txt
> > > file is always locked. I also tried to delete it after
> returning to the
> > > sleep processing, but it was still locked. I don't want to exit out of
> > > the process with the SLEEP command, but I need to delete the file once
> it
> > > has been imported. What am I missing?
> >
> > Which OS?
> >
> > If *nix, then file ownership might be an issue.
> >
> > In general, are you doing a CLOSE on the import handle before you try to
> > remove it?  You should be, although this is far more likely to
> be an issue
> > only on Windows.
> >
> > mark->
> > --
> >           *****   Fairlight Consulting's Software Solutions   *****
> > OneGate Universal CGI Gateway:
> http://onegate.fairlite.com/
> > FairPay PayPal Integration Kit:
> http://fairpay.fairlite.com/
> > RawQuery B2B HTTP[S] Client & CGI Debugger:
> http://rawquery.fairlite.com/
> > Lightmail Mail Sending Agent:
> http://lightmail.fairlite.com/
> > FairView Image Viewer for Integration:
> http://fairview.fairlite.com/
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list