Immediate Updates on Table

I am using VB with Access in Windows NT.
How to Update Records Immediately?

I am Working with Stock Program When two user make the sales for same item. Stock goes negative.
ackid32Asked:
Who is Participating?
 
vikiingCommented:
If two different stations address the same product, both will think "There are 50 units of this", then one will sell 40, and the other will sell 30, leaving, in both cases the wrong value for the remaining stock.

To handle that situation, you need a semaphore which indicates when a certain record is available to use. If semaphore indicates a certain resource (in this case, the item record) is locked, then you must wait until the record is unlocked (the other application fress the record once it was updated).

Some data base managing systems handle semaphores automatically (which are intended for multi-modifying-users access); some others, simply not, and therefore, you must develope the concurrency control.


0
 
altenaCommented:
Issue an SQL update command.

Send a SQL statement such as:

UPDATE STOCK_TABLE
    set stock_level = stock_level -100
  where stock_id = 9987

Good luck.
0
 
ackid32Author Commented:
Vikiing
im using Access as backend and how can i use semaphores
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
darinwCommented:
Reviewing question.

darinw
Customer Service
0
 
darinwCommented:
Hello everyone,

ackid32 -

When you post a question you are forming an alliance with the Experts. You present your problem, your allies try to help you solving your problem. In your alliance, you must let your allies know your strategic information so that the battle can be won favorably.

So far, your allies are loosing the war because you aren't holding up your end of the bargain. They post tactical information but you never respond. They ask for air cover and no planes show up.

As I said in one of your question posts before, you must respond to the Experts when they post a comment that contains a question for you.

If a solution is presented, by way of comment or answer, you must evaluate it and report back on your findings.

You need to bring your alliance to a close for each question by either accepting an answer or deleting the question.

Here is a list of the open questions you have:

===
[This group of questions require your input]
"How to get Uniq No for Masters?"
http://www.experts-exchange.com/jsp/qShow.jsp?ta=vbdatabases&qid=10317243 

"Anywhere Banking"
http://www.experts-exchange.com/jsp/qShow.jsp?ta=vbdatabases&qid=10597901 

"Refresh Intervel"
http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=10321556 

"How to detect a Hotkey"
http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=10366318 

===

[This one appears to have been abandoned by the Experts - if you wish I can delete it and refund your points]
"Immediate Updates on Table"
http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=10321222 

===

darinw
Customer Service
0
 
ackid32Author Commented:
Comment accepted as answer
0
 
ackid32Author Commented:
pls reply me
0
 
vikiingCommented:
Semaphores are special indicators which handle the way a multiple-users transaction is carried over. As a rule, the own DBMS handles them, this is, the data base management system is who "serializes" concurrent transactions to execute one at a time, as if they weren't performed simultaneously.

But if your DBMS doesn't use them, then you must implement the semaphore scheme by yourself. Read some data base literature.

Thanks x the points.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.