Groups > dBase > dBase whish list > use exclusive




use exclusive

use exclusive
Wed, 16 Apr 2008 18:33:48 -040
I wish dbase would add a code to see if the command use <sometable>
exclusive really worked.
  The file opens but if it is in use elsewhere the file is opened BUT not
exclusive and any command issued requiring exclusive use gets a unrecoverable
error massage.
There is , I believe a simple solution.Dbase tests the file and opens it
exclusive only if it can, or else it opens it NOT exclusive. Not only that it
displays a message on the success of the command in the lower right pane bottom
in the IDE command window :
test this yourself 
in the command window
type 
close database // close them all for the test
select 1 
use anytable 
and in the lower right of your screen are 4 boxes for  display
1. the table name  
2. isblank() // this is the one we are concerned about
3. row you are on plus "/" and number of records in table
4. "Ins" or "Ove"

 testing farther :
in the command window type
select 2
use anytable exclusive
the 4 boxes now display
1. the table name  
2.  isblank()   // even though you entered "Exclusive "
3. row you are on plus "/" and number of records in table
4. "Ins" or "Ove"

To finish the test:
in the command window
type 
close database // close both instances of anytable
use anytable exclusive
Boxes 2.  NOW DISPLAYS "Exclusive " NOT isblank()  
This proves Dbase opens the file properly Saves the result somewhere AND
visually displays the answer to the user.   
   Why not add some code to Dbase that returns the state of box number 2 to the
progrmmer or surfce the location of box # 2 so the programmer could test for
it's value?

Simple (I hope), But elegant.
Remember this is not a bug, it is predictable but inconsistant, and there is no
documentation to warn the user of it's results baseed on other factors beyoud
the users control.
If you choose to leave a method to test Box# 2 here I would be happy to pass it
along to the newsgroups and the uDLFP.
Thanks!
John Jay 
Charter member 504 
 


Post Reply
about | contact