From: roydoc@NOMORESPAMcox.net   
      
   Hi Gene,   
      
    >When the workstation is idle IDLE for about   
    >1 hour, my IF NOT tc.qlocate(empID) would fail   
      
   I'm not sure why it fails, but I can tell you that using TCursors and   
   any other Paradox specific construct against a CS database will only   
   lead to  problems. It is not a question of if, but when. In the time it   
   takes you to figure this out, you can probably replace the TCursor with   
   a Firebird stored procedure using SQL which will work reliably every   
   time. Probably not what you wanted to hear, but I believe it is by far   
   the best way to go.   
      
   Regards,   
   RoyF   
      
      
      
   Gene De Guzman wrote:   
   > Hi All,   
   >   
   > I have a timekeeping system that is connected thru a mapped drive to a   
   > firebird DB.   
   > Everything works fine when a lot of people are coming IN & OUT.   
   > When the workstation is idle IDLE for about 1 hour, my IF NOT   
   > tc.qlocate(empID) would fail for all subsequent users and the user would   
   > need to exit my application and go back in (not logoff the PC but only exit   
   > pdox) and everything works fine again.   
   >   
   > All power schemes for the PC and NICs are set to never.  We even added a   
   > registry entry in the server to allow unlimited autodisconnect timeout but   
   > this has not solved te problem.  Before a tc.qlocate(empID) is performed, we   
   > have IF NOT tc.Open(":DATA:EMPFILE")  ... and this does not raise an error.   
   > I have a timer running on the form that displays the date and time.  We have   
   > tried to duplicate the problem in another small server and the problem does   
   > not happen.   
   >   
   > Any ideas?   
   >   
   > TIA.   
   >   
   > Gene   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)