Date:  07/19/2006 06:29:19 AM Msg ID:  003061
From:  Thread:  003025
Subject:  Re: perplexing intermittent error
 James,

openDbfs() now looks like this:

close data all
use .\database\people in 0 alias PEOPLE
use .\database\workOrders in 0 alias WORKORDERS
use .\database\prices in 0 alias PRICES
use .\database\charges in 0 alias CHARGES
use .\database\waiver in 0 alias WAIVER
use .\database\chargesadhoc in 0 alias ADHOC
use .\database\payments in 0 alias PAYMENTS
use .\database\mess in 0 alias MESS
set dele on
retu(.t.)

I just quickly checked to see if it was bug free. It is. The files all opened and did so quickly. I'll report back in a few days. I hope the above fixes the problem.

Thanks.

Alden
Sent by James Williams on 07/19/2006 06:13:38 AM:
I still recommend making sure that the environment is clean. Close all tables and then open (if you are on a shared server). using "Use data\tablename in 0"
Sent by on 07/19/2006 05:18:20 AM:
 Hello,

My openDbf() now looks like this:

close data all
if !used("PEOPLE")
  sele 0
  use .\database\people alias PEOPLE
endif
if !used("WORKORDERS")
  sele 0
  use .\database\workOrders alias WORKORDERS
endif
...

I'm still getting the 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.

Any more ideas?

Ciao,

Alden



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