Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 136
  • Last Modified:

Exclusive tables-HELP!!!!

Im not really familiar with that. I put my table called tableFolder at Exclusive = true in the beginning.

I want that when someone enters his or her password,it deletes everything in that table if no one else is using the table in the sametime, if someone else is using the table, then it doesn't do the operation. How do I that???
0
fb132
Asked:
fb132
1 Solution
 
ILECommented:
if table is set to exclusive only one cen use the table
0
 
fb132Author Commented:
I know that.My question is 2 people are using my program, right, I want that the second person to go, the program verifies first of all if someone is already using the database and if there is, well a popup message appears.
0
 
RatjeCommented:
If the table is set to exclusive then only one person has access to it ( the one who set it to exclusive).
You could use this to determine if anybody else is using the table .

table.close ;
try
 table.Exclusive := true ;
 if this works you're the only one using the table
 start deleting our records
except
 table.open ;
 show your message or whatever, other user active
end ;



Rat
0
 
RatjeCommented:
If the table is set to exclusive then only one person has access to it ( the one who set it to exclusive).
You could use this to determine if anybody else is using the table .

table.close ;
try
 table.Exclusive := true ;
 if this works you're the only one using the table
 start deleting our records
except
 table.open ;
 show your message or whatever, other user active
end ;



Rat
0
 
CleanupPingCommented:
fb132:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now