X-Mailer: ELM [version 2.3 PL11]
Newsgroups: bit.listserv.novell
Date:         Wed, 8 Apr 1992 08:09:20 PDT
Reply-To:     Novell LAN Interest Group <NOVELL@SUVM.BITNET>
From:         Richard Warner <ames!sjsumcs.SJSU.EDU!rick@HARVARD.HARVARD.EDU>
Subject:      Re: Foxpro/Novell
X-To:         Novell List Server <Novell@suvm.acs.syr.edu>
              D'Arrigo" at Apr 8, 92 4:08 am

I have not had this problem with FoxPro, but I had similar problems with
a competitors database product IF the amount of free RAM in the client
stations was below a crucial cut-off point.  Since one of the differences
between running it on a LAN and off the LAN is the loading of network
drivers (which eat some RAM) you might want to look at the actual
requirements of FoxPro and see if your client stations meet those
requirements.

>   Hi,
>     I'm hoping someon can help me understand what has happened to my
>      Programs I've written in Foxpro.  They were developed and tested
>    Under FoxproLn 1.2 and run without error.  However when I install them
>      On the network, bad things begine to happen.
>
>    1) When the user tries to retrieve a record he is first prompted
>       for the records unique key (in this case its a combination of the date
>       and employee number).  This key is then used as the target key when
>       the database is searched.  For example,
>
>     @ 2,2 Get mDate
>         @ 3,2 Get mEmployee
>         Read
>         TargetKey = DToC(mDate)+mEmployee
>         Select Workfile Index Date_Emp
>         Seek TargetKey
>         If Found()
>             Do DisplayRec
>             Do EditRec
>         Else
>             Do AddRec
>         EndIF
>
>       SO the database is searched, if a record with the same key is located
>       then the record is displayed and the user is allowed to edit it.
>       If a correspoonding record is not found,  the system will assume that
>       it is a new record and proceed accordingly.
>
>       The problem arises with the fact that the system doesnt always find
>       the record, even when it is there. (I have BROWSEd the file and have
>       seen the record there).  This problem mysteriously disappears when
>       I take it off the Netware Lan.
>
> 2)  Another problem that has caused some grief since it was installed on the
>      network is that garbage has somehow gotten into the database  (GASP!)
>      I Deleted and packed the databse removing those records which were
>        destroyed.  I have since removed the application for the network
>      and all is fine, but this is only a short term patch.
>
> As you may be able to tell, this is my firfst netowrk application I have
> written, and any explaination of why this is happening and how to fix it
> would be GREATLY appreciated.
>
> If this is posted in the wrong area, my appoligies, I figured since the
> problem arose only when iunstalled on a Netware Lan, I figured this might be
> a good place to start.
>
> Thank You.
>
> *****************************************************************************
> Christopher D'Arrigo
> SUNY@Buffalo
> In%"v064qpfu@ubvmsb"
> ******************************************************************************
>

+-----------------------+-------------------------------------+
|   Richard M. Warner   |   Internet:  rick@sjsumcs.sjsu.edu  |
|                       | CompuServe:  71121,2257             |
+-----------------------+-------------------------------------+
|  ** DISCLAIMER:  All opinions are strictly my own.  I work  |
|                  hard enough at forming them!               |
+-------------------------------------------------------------+
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU