Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Immediate Updates on Table

Posted on 2000-04-01
8
Medium Priority
?
240 Views
Last Modified: 2010-05-02
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.
0
Comment
Question by:ackid32
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 3

Expert Comment

by:altena
ID: 2675985
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
 
LVL 3

Accepted Solution

by:
vikiing earned 100 total points
ID: 2676724
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
 

Author Comment

by:ackid32
ID: 2683181
Vikiing
im using Access as backend and how can i use semaphores
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 3

Expert Comment

by:darinw
ID: 2900354
Reviewing question.

darinw
Customer Service
0
 
LVL 3

Expert Comment

by:darinw
ID: 3641874
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
 

Author Comment

by:ackid32
ID: 3680283
Comment accepted as answer
0
 

Author Comment

by:ackid32
ID: 3680284
pls reply me
0
 
LVL 3

Expert Comment

by:vikiing
ID: 3687092
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question