ackid32
asked on
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.
How to Update Records Immediately?
I am Working with Stock Program When two user make the sales for same item. Stock goes negative.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Vikiing
im using Access as backend and how can i use semaphores
im using Access as backend and how can i use semaphores
Reviewing question.
darinw
Customer Service
darinw
Customer Service
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?"
https://www.experts-exchange.com/jsp/qShow.jsp?ta=vbdatabases&qid=10317243
"Anywhere Banking"
https://www.experts-exchange.com/jsp/qShow.jsp?ta=vbdatabases&qid=10597901
"Refresh Intervel"
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=10321556
"How to detect a Hotkey"
https://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"
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=10321222
===
darinw
Customer Service
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?"
https://www.experts-exchange.com/jsp/qShow.jsp?ta=vbdatabases&qid=10317243
"Anywhere Banking"
https://www.experts-exchange.com/jsp/qShow.jsp?ta=vbdatabases&qid=10597901
"Refresh Intervel"
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=10321556
"How to detect a Hotkey"
https://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"
https://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=10321222
===
darinw
Customer Service
ASKER
Comment accepted as answer
ASKER
pls reply me
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.
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.
Send a SQL statement such as:
UPDATE STOCK_TABLE
set stock_level = stock_level -100
where stock_id = 9987
Good luck.