Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!pt.cs.cmu.edu!andrew.cmu.edu!cs97+
From: cs97+@andrew.cmu.edu (Chun Jonathan Sun)
Newsgroups: comp.databases
Subject: Re: Databases - performance vs. price
Message-ID: <0Yn=NDy00WoBE4XUx7@andrew.cmu.edu>
Date: 25 Jul 89 18:49:51 GMT
References: <1554@unccvax.UUCP> <1735@ucqais.uc.edu> <188@labii.UUCP>,
	<2408@canisius.UUCP>
Organization: School of Urban and Public Affairs, Carnegie Mellon, Pittsburgh, PA
Lines: 54
In-Reply-To: <2408@canisius.UUCP>

The following dBase IV problems need your help.  

1. I use user defined functions as follows to maintain the input
integrity.  Whenever the functions are called from     screen format,
they check the files as the commands assigned to forthe first three or
five times.  Butthey erase    or hide the rest of data except the first
few records.  Even I use DISPLAY ALL or LIST ALL commands, I      still
can not read all records.  The status bar shows the rest records are
still there.  My computer just doesn't      allow me to read them.
    

    ** Program: CHKBDGID. PRG         &&  an user defined function

    ** This function checks if the user input in the Building ID column
is valid.  It checks the MASTLIST.DBF 
    file in a non-active work area.

     FUNCTION CHKBDGID
     PARAMETER m_bldgid

     mvalid = .T.
     SELECT MASTLIST
     SCAN FOR Bldgid = m_bldgid
             SELECT  1
             ?? 'Existing building,  you can not use this ID'
             mvalid = .F.
             RETURN mvalid
     ENDSCAN
     SELECT 1
     ?? 'New building, ID is accepted'
     mvalid = .T.
     RETURN mvalid

2. After I SET FORMAT TO MASTLIST (a .SCR format), all the full screen
commands do not do anything but      throw me back to dot prompt and
leave the screen blank.

3.  I use a procedure file to save the procedures which set up different
working environment for different               relational DBF files. 
According to Ashton Tate user menu, a procedure is closed only when SET 
                          PROCEDURE TO  or CLOSE PROCEDURE command is
used.  The procedure file has five procedures, 
      they are almost the same exceptusing different DBF files.  Every
time when I want to change the 
      environment setup, the computer reponses "File does not exist".  I
have to reissue the SET PROCEDURE 
      TO <Procedure Name> command before DOing the actual procedure call.

4.  Has your computer ever stalled in dBase IV operation without reason?
 For example, when I use view to 
     query some specific question, it takes at one or two hours just to
locate the records being queried.
 
Thank you all for replying your answer.