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.)