|
| 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
|
|
|
|
|
|
|
|
|
|