Date:  07/06/2006 02:38:59 PM Msg ID:  003026
From:  James Williams Thread:  003025
Subject:  Re: perplexing intermittent error
1. is the opendbfs function you have listed complete or have you cut it down to post on the forum. There could be a another database opening in that work area.
 
2. Do you have close database after script finishes selected in the control centre.
 
3. have you tried just opening the table at the top on the script without using the function.
 
Sent by on 07/06/2006 02:04:09 PM:
Hello,

I'm getting a perplexing intermittent error:

 There was an error during the interpretation of your request.

Error #:              13
Message:         Alias 'WORKORDERS' is not found.
Program:         c:\inetpub\potter\stoutmarinedatabase\mgmt.fxp
Line #:         9
Line:         sele WORKORDERS

If I hit the browser's refresh the error vanishes and all works fine.

mgmt.fwx
line 8 =openDBFs()
line 9 sele WORKORDERS

opendDBFS.prg
if !used("PEOPLE")
  sele 1
  use .\database\people alias PEOPLE
endif
if !used("WORKORDERS")
  sele 2
  use .\database\workOrders alias WORKORDERS
endif
retu(.t.)