Path: utzoo!censor!geac!torsqnt!lethe!telly!attcan!uunet!munnari.oz.au!uhccux!ames!elroy.jpl.nasa.gov!decwrl!deccrl!news.crl.dec.com!shlump.nac.dec.com!pasm07.enet.dec.com!yychow
From: yychow@pasm07.enet.dec.com (yychow)
Newsgroups: comp.databases
Subject: some questions on DBASE III +
Summary: have questions then ask...
Keywords: make it simple....
Message-ID: <20990@shlump.nac.dec.com>
Date: 12 Mar 91 20:11:40 GMT
Sender: newsdaemon@shlump.nac.dec.com
Organization: Digital Equipment Corporation
Lines: 77

Hi Everyone, 

	I need a number of questions for you, if you know the answer
	on one or more questions listed below, please write here or
	directly sent mail to the address below.

	All below cases are to be assumed in a network environment.

	1) If I have two applications say prog1 and prog2, and want to
	   have a main menu (main) to call up either one of them. Do I 
	   need to re-organize all the select area when multiple users 
	   is using the programs????

	                  -----	main------
			  |              |
			  |              |
			prog1		prog2
			-----		-----
			select 1 	select 1
			use test1	use test2

	   If not so, I shall assume that multiple users will not affect
	   each other..

	2) For a large application, it is difficult to open all the files
	   in a different selected areas once.. So if I write for each function
	   to open the the corresponding required database files and close 
	   them when I finished using them. In a single user-environment, 
	   there will not be any problem, but about when it is in 
	   a multiple users environment, will this approch affect the 
	   users using the system? 

	   Say I have two users (user1 & user2)and they are working on with 
	   the same application but different functions, will the user1 
	   affect the user2.

			user1		user2
			-----		-----
			function1      function2
			   |		  |

			select 1 	select 1
			use test1	use test2

	    Will the user1 be working on test1, and user2 be working test2
	    without affecting each other???

	3) I believe many of you have used clipper to compile your application.
	   From the reference manual, it mentions ones could open up to
	   256 areas, i.e., select 1 to select 256... But I have an application
	   which only open ten database files and 10 indexed files. whenever 
	   it reach to the area 9, it gives me an error message like "error
	   on open indexed file name_of_file", I have checked the indexed 
	   file, and re-create the indexed file, it still does not work. 
	   Can someone tell me what is wrong with it? By the way, I have set
	   the following:

		config.sys
		==========
		files = 50

		autoexec.bat
		============
		set clipper = F50

	   This should enable me to open up to 50 files, right !!!


	Thanks in advance...
			    YY.

	   
---                                                                   
 Y. Y. Chow	yychow@pasm07.enet.dec.com                       
 		---or---   ...!decwrl!pasm07.enet!yychow         
 		---or---   yychow%pasm07.enet@decwrl.dec.com     
---