Re: Error hanlding

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Patrick Tura (patrick_at_kff.ph)
Date: 04/17/04 

Date: Sat, 17 Apr 2004 17:47:19 +0800

Hi!

Thanks a lot for your reply.

I am still using VFP 6.0

Thanks.

/patrick

"Altman" <NotGiven@SickOfSpam.com> wrote in message
news:eOXOuP7IEHA.2656@TK2MSFTNGP11.phx.gbl...
> what version of VFP are you on? If you are on version 8 you can use the
TRY
> CATCH routine.
> TRY
> USE verification in 0 Exclusive
> CATCH to loError
> **if there is an error it will go here and you can pop up a message to
> say whatever you want
> FINALLY
> ENDTRY
>
>
> "Patrick Tura" <patrick@kff.ph> wrote in message
> news:uPDBdU6IEHA.2524@TK2MSFTNGP11.phx.gbl...
> > Hi!
> >
> > I got one table that is necessary to let only one user to open at a
time.
> I
> > need to find out if the table is occupied or not before the user can
> execute
> > a command 'use \\kffserver\kffmaindbf\verification.dbf exclusive ' so
> > that I can give a message to the user that the table is occupied and
tell
> > him to try later instead of file access is denied or give this command
> > " messagebox("Verification is occupied, please RETRY",0,"Busy")".
> >
> > I was trying to use this command but this seems not to work over the
> network
> > maybe valid only for the local data environment?
> >
> > if used('verification')=.F.
> > use \\kffserver\kffmaindbf\verification.dbf exclusive
> > else
> > messagebox("Verification is occupied, please RETRY",0,"Busy")
> > endif
> >
> > Thanks a lot.
> >
> > /patrick
> >
> >
>
>

Relevant Pages

  • Re: Select - SQL vs. SUM
    ... If you have to use an earlier version of VFP earlier than 9, ... >> also force VFP to read from the buffer with a new clause in the SQL ... >> The SELECT command doesn't move the record pointer in the grid's record ... >>> I have a grid whose recordsource is a table named _payments. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Window XP Error Accessing File
    ... the command prompt and even get an error when I try a windows drag and drop. ... VFP reports its my OS.. ... My OS is Windows XP with all updates and service packs on a IBM NetVista ...
    (microsoft.public.windowsxp.basics)
  • RE: Missing VFP Printjobs
    ... I would try adding the following command immediately after the REPORT FORM ... This command forces VFP to close and release the print job. ...
    (microsoft.public.fox.vfp.reports.printing)
  • Re: Preventing Tight Loops
    ... the bettter way to get the ESC key working is holding it down. ... I don't know if OS has much influence here, it's the responsibility of a process (VFP runtime) to respond to windows messages. ... ON commands define interrupts, especially ON KEY works much better for that reason, but still a single command is a single command and the single threaded nature of VFP makes it react only sparsely. ... It's a good idea in the sense of keeping your app responsive to change from the "monolithic" REPLACE ALL / REPLACE FOR to a loop of single replaces. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: dbf file not a table
    ... This is the VFP COPY command, ... sherry wrote: ... Have tried setting validation to 0 and open, no luck. ...
    (microsoft.public.fox.programmer.exchange)